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