Convert JULIAN to standard date using SQL.

EnterpriseOne stores dates in Julian using the following format CYYDDD ("C" is the century, "YY" is the year and "DDD" is the number of days since the start of the year).

To convert a julian date to a standard (gregorian) date format:

TO_CHAR(TO_DATE(XXXXXX+1900000,'YYYYDDD'),'MM-DD-YYYY')

Notes:
- where XXXXXX is the column name to convert.
- this only works on 19th century onwards.

Or

You can download this QuikDates! "freeware" windows application that can convert julian to standard and vice-versa. It's a handy tool (no need to install) that you can place on your desktop.
Download here!