|
CCYYMMDD seems to be the convention...it's also nice because you can sort on the date. > -------- Original Message -------- > Subject: Re: "Date" fields > From: Jeffrey Young <cooljeff913@xxxxxxxxx> > Date: Mon, May 09, 2005 12:01 pm > To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> > > Most places that I have been at have adopted the CCYYMMDD (20050501) date > format for all dates. > > Steve Landess <sjl_abc@xxxxxxxxxxx> wrote:Date field question... > > There may be a few exceptions, but in JDE all date fields are generally > defined as a 6-digit julian format - 105001, for example, indicates > 1-January-2005. 099001 indicates 1-January-1999. (The '1' prefix indicates > that the date is in the 21st century, a '0' prefix indicates 20th century). > > Let's say you're defining a date/timestamp field (14,0 Zoned) -or- a date > field (8,0 Zoned) in a non-JDE data base (DB2). Is our industry, is there a > standard for populating these types of field? I have an idea as to how they > should be populated, but would like another's opinion. > > Please do not confuse my question with the "date" data type that is now > available. I believe that the customer's requirement is to have this field > defined as a numeric field... > > Regards, > > Steve > > > -- > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list > To post a message email: MIDRANGE-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/midrange-l > or email: MIDRANGE-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > > > > > Jeff Young > Dynax Solutions, Inc. > IBM Certified Systems Exper - iSeries Technical Solutions V5R2 > > > > > > > > > --------------------------------- > Yahoo! Mail Mobile > Take Yahoo! Mail with you! Check email on your mobile phone. > -- > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list > To post a message email: MIDRANGE-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/midrange-l > or email: MIDRANGE-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.