Re: Storing dates - revisted...

[eric.delong@xxxxxxxxxxxxxxxxx]

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