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 8: explain analyze is your friend
