jeudi 19 février 2015

PLSQL: random timestamp between 2 timestamps

I have a timestamp which represents the current timestamp:


now := CURRENT_TIMESTAMP; tomorrow := now + INTERVAL '1' DAY;


Now I want to render a random timestamp between those 2 values, I tried with DBMS_RANDOM but it doesn't work


Any Help?





Aucun commentaire:

Enregistrer un commentaire