SQL> select sysdate from dual;
SYSDATE
---------
02-DEC-08
SQL> select trunc(sysdate) from dual;
TRUNC(SYS
---------
02-DEC-08
SQL> select trunc(sysdate,'mm') from dual;
TRUNC(SYS
---------
01-DEC-08
SQL> select trunc(sysdate,'dd') from dual;
TRUNC(SYS
---------
02-DEC-08
SQL> select trunc(sysdate ,'yyyy') from dual ;
TRUNC(SYS
---------
01-JAN-08
比较一下,自然会发现trunc函数的用法。