×
1-888-308-ERP1

Tech Tip: Julian Date Conversion, Oracle SQL

May 28, 2019

 

Oracle SQL formulas:

Julian to Gregorian: to_char(to_date(substr(E1JulianField,2,5),'YYDDD'),'YYYY-MM-DD') Gregorian to Julian: to_char(to_date('2015-01-01','YYYY-MM-DD'),'YYYYDDD')-1900000