取100天内的随机时间精确到秒:
SQL> SELECT TO_DATE (TRUNC (DBMS_RANDOM.VALUE (TO_NUMBER (TO_CHAR (SYSDATE - 100,
2 'J'
3 )
4 ),
5 TO_NUMBER (TO_CHAR (SYSDATE, 'J'))
6 )
7 ),
8 'J'
9 ) + DBMS_RANDOM.VALUE (0, 1)
10 FROM DUAL;
TO_DATE(TRUNC(DBM
-----------------
20110617 02:34:56
SQL> /
TO_DATE(TRUNC(DBM
-----------------
20110703 04:33:09
SQL> /
TO_DATE(TRUNC(DBM
-----------------
20110508 13:23:17
SQL> /
TO_DATE(TRUNC(DBM
-----------------
20110523 04:36:26
取100天内的随机时间,精确到天:
SQL> SELECT TO_DATE (TRUNC (DBMS_RANDOM.VALUE (TO_NUMBER (TO_CHAR (SYSDATE - 100,
2 'J'
3 )
4 ),
5 TO_NUMBER (TO_CHAR (SYSDATE, 'J'))
6 )
7 ),
8 'J'
9 )
10 FROM DUAL;
TO_DATE(TRUNC(DBM
-----------------
20110616 00:00:00
SQL> /
TO_DATE(TRUNC(DBM
-----------------
20110606 00:00:00
SQL> /
TO_DATE(TRUNC(DBM
-----------------
20110514 00:00:00
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10972173/viewspace-703612/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10972173/viewspace-703612/