RE: Case stmt in SQL

DateToDec and DecToDate procedures... they now support a date format code of
"*JDE" in addition to all of the regular (and some irregular) date formats.
Thanks
-Bob Cozzi



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of darryl.mavin@xxxxxxxxxxxxxx
Sent: Thursday, November 25, 2004 4:31 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Case stmt in SQL


I can't help you wit this but I've always wondered what a JDE julian date
format looked like. Can you give an example?
-Bob Cozzi

Example of a JDE Julian Date : 104366 =  31 Dec 2004
The first digit identifies the century, the next two digits represent the
year, and the last three digits is the number days.



The opinions expressed within this email represent those of the individual
and not necessarily those of Gullivers Travel Associates (GTA).
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify
postmaster@xxxxxxxxxxxxxx
Should you wish to use email as a form of communication, GTA are unable to
guarantee the security of email content outside of our own computer systems.



______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.