Re: Specifying dates in DDS

owner-midrange-l@midrange.com wrote:

> Dave, think about taking another look at L date.
>
> After Carr and a few others beat on me a while back about dates, I decided
> I'd better listen to the best in the business, or unsubscribe.  I have to
> admit that the re-think changed my mind.  L date works.
>

Yes I know L date works and I use it all the time from the time IBM introduced
it.  But I prefer to store them as CCYYMMDD which gives me some flexibility.
What I would like IBM to do is offer the L date in display files.  Also I wish
they allowed the system date (the DATE keyword) in DDS display to sport the
Y2K
format.  But lowly V3R2 people like us cant get what the lordy V4R2 does !

> In <350EAFDE.8EFEA128@fuse.net>, on 03/17/98
>    at 12:16 PM, Dave Mahadevan <mahadevan@fuse.net> said:
>
> >I prefer storing the date as CCYYMMDD.  This can be easily moved into
> >*USA (MM/DD/CCYY) *EUR (DD.MM.CCYY)date fields for display/print.
> >However, if you use Query or SQL a lot, then date conversion within is
> >cumbersome (can be done). Also, this will also allow you the special all
> >0 or all 9 date approach.  Best of all, you still have your old date as
> >part of your new date!  You can easily write a proc to supply you with
> >various forms of dates for display/print. --
>

--
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@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
+---