declare
var_date date;
begin
var_date := to_date('1980-01-01','yyyy-mm-dd') + 1000;
dbms_ourput.put_line(var_date);
end;
var_date date;
begin
var_date := to_date('1980-01-01','yyyy-mm-dd') + 1000;
dbms_ourput.put_line(var_date);
end;
-----------------------
46SQL> select trunc(mod(10000,60)) from dual;TRUNC(MOD(10000,60))
--------------------
40SQL>
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
小时分秒格式
select to_char(sysdate,'hh24:mi:ss') from dual;