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)
Examples[edit]
SELECT trunc(SYSDATE,'month') FROM dual;
Also see[edit]
