trunc(date)函数

将日期取整的函数，测试如下：

SQL> select trunc(sysdate,'YEAR') FROM DUAL;

TRUNC(SYSDATE,'YE
-----------------
20090101 00:00:00

SQL>  select trunc(sysdate,'mon') from dual;

TRUNC(SYSDATE,'MO
-----------------
20090301 00:00:00

SQL>  select trunc(sysdate,'dd') from dual;

TRUNC(SYSDATE,'DD
-----------------
20090327 00:00:00

SQL> select trunc(sysdate,'hh24') from dual;

TRUNC(SYSDATE,'HH
-----------------
20090327 10:00:00

SQL> select trunc(sysdate,'mi') from dual;

TRUNC(SYSDATE,'MI
-----------------
20090327 10:43:00

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10972173/viewspace-580327/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10972173/viewspace-580327/