Oracle PL/SQL: Date Functions: Round (date) - The round function returns a date rounded to a specific unit of measure

Quick Search:

Oracle PL/SQL: Date Functions: Round (date)

Jump to:

Category: >> Oracle PL/SQL >> Date Functions: Round (date)

<< last

next >>

Snippet Name: Date Functions: Round (date)

Description: The round function returns a date rounded to a specific unit of measure

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: March 03rd, 2009

SELECT ROUND(TO_DATE ('22-AUG-03'),'YEAR') FROM dual;
returns '01-JAN-04' 
 
SELECT ROUND(TO_DATE ('22-AUG-03'),'Q') FROM dual; 
returns '01-OCT-03' 
 
SELECT ROUND(TO_DATE ('22-AUG-03'),'MONTH')  FROM dual;
returns '01-SEP-03' 
 
SELECT ROUND(TO_DATE ('22-AUG-03'),'DDD')  FROM dual;
returns '22-AUG-03' 
 
SELECT ROUND(TO_DATE ('22-AUG-03'),'DAY')  FROM dual;
returns '24-AUG-03'