TRUNC is a SQL function that truncates a DATE or NUMBER value.
Date values:
trunc (date) trunc (date, 'format-string')
Number values:
trunc (a-number) trunc (a-number, other-number)
SELECT trunc(SYSDATE,'month') FROM dual;
