JD Edwards EnterpriseOne Documentation Library

If your new to Oracle's JD Edwards EnterpriseOne and need something to read and learn...you can start downloading or viewing online the systems implementation and tools-guide documentation via this link:

http://www.oracle.com/technology/documentation/jdedent.html

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!