Oracle PL-SQL code to convert JDEdwards Julian Dates to dates / formatted strings From http://sqlfiddle.com/#!4/42244/1

JDEJulianDatesInOracle.sql

select julianDateCol 
, case 
  when nvl( julianDateCol ,0)=0 
    then 'no date' 
  else to_char
        (     
          to_date
          (       
            1000 * 
            (
              to_number
              (
                substr(lpad(to_char( julianDateCol ),6,'0'),1,3)
              )
              +1900
            )          
            + to_number
              (
                substr(to_char( julianDateCol ),length(to_char( julianDateCol ))-2,3)
              )         
            ,'YYYYDDD'     
          )     
          ,'DD-MON-YYYY' 
        ) end FormattedDate 
from SomeTable;