Snippet Name: Date Functions: TRUNC (date) Description: The trunc function returns a date truncated to a specific unit of measure. Also see:» FUNCTIONS: Deterministic » FUNCTIONS: Nested Functions » FUNCTIONS: IF statement » FUNCTIONS: date/time » FUNCTIONS: Sample functions » FUNCTIONS: drop » FUNCTIONS: Recompile » FUNCTIONS: DEBUG mode » FUNCTIONS: IN OUT parameter » FUNCTIONS: with output parameters » FUNCTIONS: with parameters » FUNCTIONS: without parameters » FUNCTIONS: Create function » FUNCTIONS: special restrictions » FUNCTIONS: System Privileges » IN Function » Built-In Functions: CASE » Built-In Functions: DECODE » SUBST and INSTR together » INSTR (InString) » SUBSTR (SubString) » String Functions: REVERSE » String Functions: LENGTH » String Functions: INSTR » String Functions: CONCAT » String Functions: CHAR » String Functions: INITCAP » String Functions: LOWER » String Functions: UPPER » Date Functions: NUMTOYMINTERVAL Comment: (none) Language: Highlight Mode: PLSQL Last Modified: March 03rd, 2009
Description: The trunc function returns a date truncated to a specific unit of measure.
Also see:» FUNCTIONS: Deterministic » FUNCTIONS: Nested Functions » FUNCTIONS: IF statement » FUNCTIONS: date/time » FUNCTIONS: Sample functions » FUNCTIONS: drop » FUNCTIONS: Recompile » FUNCTIONS: DEBUG mode » FUNCTIONS: IN OUT parameter » FUNCTIONS: with output parameters » FUNCTIONS: with parameters » FUNCTIONS: without parameters » FUNCTIONS: Create function » FUNCTIONS: special restrictions » FUNCTIONS: System Privileges » IN Function » Built-In Functions: CASE » Built-In Functions: DECODE » SUBST and INSTR together » INSTR (InString) » SUBSTR (SubString) » String Functions: REVERSE » String Functions: LENGTH » String Functions: INSTR » String Functions: CONCAT » String Functions: CHAR » String Functions: INITCAP » String Functions: LOWER » String Functions: UPPER » Date Functions: NUMTOYMINTERVAL
SELECT TRUNC(TO_DATE('22-AUG-03'), 'YEAR') FROM dual; returns '01-JAN-03' SELECT TRUNC(TO_DATE('22-AUG-03'), 'Q') FROM dual; returns '01-JUL-03' SELECT TRUNC(TO_DATE('22-AUG-03'), 'MONTH') FROM dual; returns '01-AUG-03' SELECT TRUNC(TO_DATE('22-AUG-03'), 'DDD') FROM dual; returns '22-AUG-03' SELECT TRUNC(TO_DATE('22-AUG-03'), 'DAY') FROM dual; returns '17-AUG-03'
