Re[2]: Storing dates - revisted...

[eric.delong@xxxxxxxxxxxxxxxxx]

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