Home > IT Answers > AS/400 > Converting Julian date to Gregorian in WrkQry
Lady55
15 pts.
 Converting Julian date to Gregorian in WrkQry
AS/400 date format, AS/400 queries, Date format, WRKQRY
I work on an Iseries AS/400 and when I do a wrkqry for reports I need to convert the date ccyyyddd(julian) to mmddyyy(gregorian)

Software/Hardware used:
ASKED: September 29, 2008  6:29 PM
UPDATED: September 29, 2008  7:10 PM
RELATED QUESTIONS
Answer Wiki:
I'm NOT an AS/400 guy but... Try these: <pre> A Standard query can do that for you. Go to "Define result fields" and create these fields. GLDGJ would be your Julian date field, and GLDAT would be your new work field. Works for pre-and post 2000. To convert a Julian date to a normal date in query: NDAT 1900000 + gldgj 7 0 CDAT digits(ndat) GLDAT date(cdat) </pre><a href="http://search400.techtarget.com/tip/0,289483,sid3_gci944437,00.html">Source</a> These might be helpful as well. <a href="http://search400.techtarget.com/tip/0,289483,sid3_gci944437,00.html">Link 1</a> <a href="http://quasar.as.utexas.edu/BillInfo/JulianDatesG.html">Link 2</a> Good Luck! -Flame
Last Wiki Answer Submitted:  September 29, 2008  7:10 pm  by  Flame   14,895 pts.
All Answer Wiki Contributors:  Flame   14,895 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _