Re: Storing dates - revisted...

[Chuck Lewis <CLEWIS@xxxxxxxxxx>]

Thanks Buck !

Sounds like we are in the same "park" :-)

When you say "native" (and pardon my ILE ignorance) do you mean YYYY ?

Chuck

Buck Calabro wrote:

> On Monday, September 21, 1998 11:29 AM, Chuck Lewis
> [SMTP:CLEWIS@IQUEST.NET] wrote:
> > More questions on date storage !
> -snip-
> > 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)... ??????/
>
> All our new RPG development is storing dates as YYYYMMDD only because we
> have back-level customers, and we started this effort on V3R1, but there
> are still lots of legacy files using YYMMDD.  Those legacy files are
> getting converted to CYYMMDD (not my choice).  Synon/2E (aka Cool) uses a
> similar format to store dates.
>
> If I were doing work for V4R1+, I would use native date data types.  This
> is what I'm using for my own tools, etc. on our V4R2 box.  They are very
> compatible with SQL and therefore ODBC and various PC products...
>
> Buck Calabro
> Commsoft, Albany, NY
> mailto:mcalabro@commsoft.net
>
> +---
> | 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
+---