Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_random

TinaAug 5 2011 — edited Aug 7 2011
I have this statement in my script..i need to generate random dates in such a way that date is not old that 365 days..
Can you please help me?I did not get the parameters they are using too...

SELECT TO_DATE(TRUNC(DBMS_RANDOM.VALUE(2455379, 2455379 + 180)), 'J') from dual
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 4 2011
Added on Aug 5 2011
4 comments
321 views