trunc 함수의 활용

select trunc(sysdate, 'year'),trunc(sysdate, 'mm'),trunc(sysdate, 'dd') from dual;

2006/01/01 00:00:00        2006/10/01 00:00:00        2006/10/03 00:00:00