RE: "Date" fields

[michael@xxxxxxxxxxxxxxxxxx]

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.