Date Functions: Round

Description: Returns date rounded to the unit specified by the format model. If you omit the format, the date is rounded to the nearest day.

ROUND(<date_value>, <format>)
 
SELECT ROUND(TO_DATE('19-OCT-00'),'YEAR') NEW_YEAR
FROM dual;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.