1、select to_date(trunc(dbms_random.value(to_number(to_char(sysdate - 30, 'J')), to_number(to_char(sysdate - 1, 'J')))), 'J') FROM DUAL;
4、返回当前回话时区的日期时间select current_timestamp from dual
Oracle数据库查询随机时间
时间：2024-10-12 00:05:221、select to_date(trunc(dbms_random.value(to_number(to_char(sysdate - 30, 'J')), to_number(to_char(sysdate - 1, 'J')))), 'J') FROM DUAL;
4、返回当前回话时区的日期时间select current_timestamp from dual