Oracle Julian Date Conversion

    Hi All,

     

    For New and Old users the julian date is a 6 digit date that all oracle databases have. So to convert this julian I attached the transformation:

     

     

    To Date:

    date(yearstart(makedate((((WASTRT - fmod(WASTRT,1000)) / 1000) + 1900))) + (fmod(WASTRT,1000) - 1)) as Date,

    To Year: 
    year(date(yearstart(makedate((((WASTRT - fmod(WASTRT,1000)) / 1000) + 1900))) + (fmod(WASTRT,1000) - 1))) as Year

     

    To Month:
    Month(date(yearstart(makedate((((WASTRT - fmod(WASTRT,1000)) / 1000) + 1900))) + (fmod(WASTRT,1000) - 1))) as Month

     

    To Day:
    Day(date(yearstart(makedate((((WASTRT - fmod(WASTRT,1000)) / 1000) + 1900))) + (fmod(WASTRT,1000) - 1))) as Day

     

    Hope This Helps