Oracle trunc함수

select sysdate, 
trunc(sysdate), 
trunc(sysdate,'year'), 
trunc(sysdate,'month'), 
trunc(sysdate,'day'), 
trunc(123.456,2), 
trunc(123.456) 
from dual

결과

16/04/23 
16/04/23 
16/01/01 
16/04/01 
16/04/17 
123.45 
123