--2011/08/24 11:10:07
SELECT SYSDATE FROM DUAL;
--2011/01/01
SELECT TRUNC(SYSDATE, 'YYYY') FROM DUAL;
--2011/08/01
SELECT TRUNC(SYSDATE, 'MM') FROM DUAL;
--2011/08/24
SELECT TRUNC(SYSDATE, 'dd') FROM DUAL;
--2011/08/24 11:00:00
SELECT TRUNC(SYSDATE, 'HH24') FROM DUAL;
--2011/08/24 11:10:00
SELECT TRUNC(SYSDATE, 'Mi') FROM DUAL;