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...?