How to convert Ordinal (Julian) Date to Calendar Date

Tools & Utilities
Highlighted
Enthusiast

Re: How to convert Ordinal (Julian) Date to Calendar Date

I found this formula that works with future dates:

SELECT TRIM ( TO_DATE ( CAST ( 2415020 + CAST ( xxxxxx AS INT ) AS CHAR(7) ) , 'J' ) ) 

Adel