月份随机:
select lpad(floor(dbms_random.value(01,12)),2,'0') from dual;
天数随机:(天数自己设置,2月只有28天)
select lpad(floor(dbms_random.value(01,30)),2,'0') from dual;
小时随机:00-24
SELECT lpad(floor(dbms_random.value(0,24)),2,'0') FROM dual;
分/秒随机:00:59
SELECT lpad(floor(dbms_random.value(0,59)),2,'0') FROM dual;
--------------------------------------------------------------------------
拼接片段
select (
to_char(sysdate, 'yyyyMMdd') ||
lpad(floor(dbms_random.value(0, 24)), 2, '0') ||
lpad(floor(dbms_random.value(0, 59)), 2, '0') ||
lpad(floor(dbms_random.value(0, 59)), 2, '0')
)
from dual;
转化为时间:
select to_date((
to_char(sysdate, 'yyyyMMdd') ||
lpad(floor(dbms_random.value(0, 24)), 2, '0') ||
lpad(floor(dbms_random.value(0, 59)), 2, '0') ||
lpad(floor(dbms_random.value(0, 59)), 2, '0')
),'yyyyMMddhh24miss')
from dual;