Monday, May 7, 2012

Convert Excel Julian date to Oracle Date datatype


SQL>  select to_date(to_char(2415019+41029),'J') dd from dual

DD    
---------
30-APR-12
1 row selected

Where 41029 is the Excel Julian Date.

No comments:

Labels