GaramX

SELECT sysdate
,trunc(sysdate)
,trunc(sysdate,'YEAR')
,trunc(sysdate,'MONTH') , trunc(sysdate, 'MM')
,trunc(sysdate,'DAY')
,trunc(123.4567,2)
,trunc(123.4567)
FROM dual

Result 18/03/09 18/03/09 18/01/01 18/03/01 18/03/04 123.45 123