返回年:
select to_char(sysdate,'yyyy') from dual;
返回月:
select to_char(sysdate,'mm') from dual;
返回日:
select to_char(sysdate,'dd') from dual;
返回小時:
select to_char(sysdate,'hh24') from dual;
返回分鐘:
select to_char(sysdate,'mi') from dual;
返回秒數:
select to_char(sysdate,'ss') from dual;
转载于:https://www.cnblogs.com/libiao/archive/2009/02/21/1395459.html