PL/SQL procedure random timestamp

how i can generate a random timestamp and put it into 开发者_运维百科a var?

Thanks,

Tommaso

I found this solution

start_date + dbms_random.value(0,86400*(end_date-start_time)+1)/86400

at

http://www.orafaq.com/forum/t/122604/2/

not real sure why but something along the lines of the following pseudocode:

find a random number in a sufficiently large range, and either add or subtract that to SYSDATE.

we have random number generater in oracle...and this random number can be used to add in sysdate to get random dates..or time stamp.