Re: Storing dates - revisted...

Thanks James !

The main reason that I'm wrestling with this is for stuff I've written; our
application code handles this. I haven't had the time to devote to the new date
stuff (haven't been in the "programming" side of things for a while and other 
stuff
was taking priority...) but it's time to start learning ! I have kept up on the
various articles, but have a ways to go to actually do anything with it <BG>...

Boy were YOU guys forward thinking (1988) !!! Congrats...

Write now (quick and dirty) I've settled on a routine that checks SYSVAL 
QCENTURY
and then adds a 19 (if 0) or a 20 (if 1) to the "first" part of the year deal,
using a bunch of DATA AREAS and "flip-flopping" things around. I'm talking files
with no more than 100-200 records in them so not much impact...

I am even using an edit word to edit MMDDYYYY to MM/D/YYYY for the screen 
display !

Which brings up ANOTHER point - what are people doing about the actual "output" 
?

Including the WHOLE date (i.e. 09/23/1998) or sticking with the "norm" 
(09/23/98) ?

I wasn't sure what the thoughts were on if 01/10/00 is going to confuse users,
where 01/01/2000 would be clearer ??

TO THE BOOKS !!!!

Thanks !

Chuck

James W. Kilgore wrote:

> We adopted the CYYMMDD format (in 1988) for one reason and one reason only:
>
> That's what the command processor returns on a *DATE parameter type.
>
> It also only occupies 4 bytes of disk space (the same as a date data type from
> what I've read).
>
> We even tried to get "cute" by outputting an "x" (unsigned) edit code to have 
>a
> packed 4 space , 8 digit YYYYMMDD field loooong before date data types (CPF 4)
> but "cute" was more trouble than it was worth. (it didn't work)
>
> IMHO, if you have the opportunity, do the "L" date thing and be ready for the
> next millennium.
>
> James W. Kilgore
> qappdsn@ibm.net
>
> DAsmussen@aol.com wrote:
>
> > Chuck,
> >
> > In a message dated 98-09-21 13:41:01 EDT, you write:
> >
> > > You can change all of your old date storage in files from YY/MM/DD to
> > >  YYYY/MM/DD. Is that what folks are doing ?
> >
> > One vote for CCYYMMDD...
> >
> >
> > "A man who is not a liberal in his youth has no heart.  A man who is not
> > conservative in his later years has no brain." -- Otto Van Bismarck
> >
>
> P.S. Dean,  The way I heard it, it was Ben Franklin: "If you're 20 and not a
> socialist you have not heart.  If you're 30 and still a socialist you have no
> brains."  It's that darn revisionist history!
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---