Err, I just read my latest digest and saw the solution:
update datafrenzy.jobdata set entered_dt= now() - CAST(round(random()*45)
|| ' days' AS interval);
- Greg
>Hello,
>
>I have a table with a timestamp column and I want to set this to a value
>of now() - a random number of days between 0 and 45 for each row... I've
>tried to do this a bunch of different ways and can't figure it out...
>Here is my latest version:
>
>
>update sometable set entered_dt = now() - interval round(random()*45)||'
>days';
>
>
>Any ideas on the proper way to accomplish this?
>
>Thanks!
>
>- Greg
>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
