sql - PostgreSQL Get a random datetime/timestamp between two datetime/timestamp

Question

The title is pretty much explicit, my question is if i get two dates with hour:

• 01-10-2014 10:00:00
• 01-20-2014 20:00:00

Is it possible to pick a random datetime between these two datetime ?

I tried with the random() function but i don't really get how to use it with datetime

Thanks

Matthiew

question from:https://stackoverflow.com/questions/22964272/postgresql-get-a-random-datetime-timestamp-between-two-datetime-timestamp

Answer 1

You can do almost everything with the date/time operators:

select timestamp '2014-01-10 20:00:00' +
       random() * (timestamp '2014-01-20 20:00:00' -
                   timestamp '2014-01-10 10:00:00')