Oracle数据库查询随机时间

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