date problems

[BigBadDave]

How can I make dates earlier than 1970 and later then 2030 becuase if I go hight or lower than these then it gives errors ? Regards

Big Bad Dave

davidbyng@hotmail.com

 

[mcvdmvs]

what functions and timenotations do you use?
negative timestamps represent dates before 1970. mcvdmvs
"It never hurts to help" -- Eek the Cat

 

[KarveR]

Do you use mysql BBDave?
//curdate() represents today.
$int_type=year; // can be day month or year

$interval=50; // how many of $int_type you want to go +-

// for interval to go back in time you need EITHER set it -50 OR use date_sub(blah ..... instead.

select date_add(curdate(),interval '$interval' '$int_type');
This will return todays date 50 years in the future. ***************************************
Party on, dudes!