Re: Storing dates - revisted...

GREATLY !

I've got a lot to look at, and as usual, the list KICKS BUTT !!

Thanks Eric !

Chuck

eric.delong@pmsi-services.com wrote:

>      Ok, lets see if I get this right... <g>
>
>      The quick and easy answer: Dates are (more or less) represented as
>      character data with valid separator characters.
>
>      A slightly better answer: A date field, when defined in a file,
>      program, etc. is given attributes  describing the various
>      formatting options like *YMD, *ISO, *USA, *MDY, sep chars......
>
>      Values stored in this field are validated by the system. All dates
>      are stored internally as if they have a century, regardless of the
>      presentation attribute. This allows the system to convert this date
>      to any known format dynamically. The real advantage, however, comes
>      from a slew of new opcodes specifically designed to support date
>      and time data. Date math lets you easily determine duration
>      (adddur, subdur), reformat data(move(d)), and so on.
>
>      I haven't used date types very much yet. Just on new projects. I'm
>      also developing on v3r2. Date support is fairly comprehensive, but
>      it gets much better at v4r2.
>
>      HTH
>      eric.delong@pmsi-services.com
>
> ______________________________ Reply Separator 
>_________________________________
> Subject: Re: Storing dates - revisted...
> Author:  <MIDRANGE-L@midrange.com > at INET_WACO
> Date:    9/21/98 2:14 PM
>
> Thanks Eric !
>
> I agree on the "window" deal. Quick NOW and SURE it will be written just like 
>YY
> as
> OK "back then"...
>
> I need to get up to speed on ILE.
>
> How are you saying that it will store this via the date data type ?
>
> Thanks !
>
> Chuck
>
> eric.delong@pmsi-services.com wrote:
>
> >      Chuck,
> >
> >      We standardized on CCYY/MM/DD (8N0) for our Y2K conversion. I
> >      personally prefer this to using a "date window" approach since you
> >      may have to change program logic the next time the window moves. I
> >      *hope* I'm not still programming in 2053, but you never know!? ;)
> >
> >      With all of the advances with date data types and support in ILE, I
> >      think the better long-term approach might be to start using
> >      date/timestamp datatypes now.
> >
> >      JMHO
> >      eric.delong@pmsi-services.com
> >
> > ______________________________ Reply Separator
> _________________________________ > Subject: Storing dates - revisted...
> > Author:  <MIDRANGE-L@midrange.com > at INET_WACO
> > Date:    9/21/98 11:28 AM
> >
> > More questions on date storage !
> >
> > 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 ?
> >
> > We are on V4R1 and IBM is storing the QYEAR as YY and then there is
> > QCENTURY as 0=1920-1999 and 1=2000=2053.
> >
> > It seems to me that YYYY/MM/DD is the better way to go (more
> > straightforward) as century really is "clumsy" )have to remember where 0
> > and 1 start and stop)... ??????/
> >
> > Or does it matter ?
> >
> > What's everyone doing ?
> >
> > We have a software package that is storing Century as 2 digits and has
> > 19 in it !!!
> >
> > Thanks !
> >
> > Chuck
> >
> > +---
> > | 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
> > +---
>
> +---
> | 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
> +---

+---
| 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
+---