Re: Specifying dates in DDS

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.


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

-- 
-----------------------------------------------------------
boothm@ibm.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
+---