[ORACLE] TRUNC 함수 한방정리

예문

SELECT SYSDATE
, TRUNC(SYSDATE)
, TRUNC(SYSDATE, 'YEAR')
, TRUNC(SYSDATE, 'MONTH')
, TRUNC(SYSDATE, 'DAY')
, TRUNC(123.4567,2)
, TRUNC(123.4567)
FROM DUAL


결과

2013/01/21 21:13:18
2013/01/21 00:00:00
2013/01/01 00:00:00
2013/01/01 00:00:00
2013/01/20 00:00:00
123.45
123