Thread: Date operation
06-06-06, 03:27 #1Registered User
- Join Date
- Aug 2004
Unanswered: Date operation
I want to adjust the date by a random amount....
I suppose it should be something like:
UPDATE xxxx SET date1 = date1 - interval (random() * 7)
anyway, i tried a lot of combination... (yes, i hd read the manual), can anyone help...?