RE: date data types, formatting in STRSQL

["Mohammad Tanveer" <mtanveer@xxxxxxxxxxxxxxxxx>]

Interesting it seems like people who were born before 1940 have invalid DOB
:-)

One solution might be to create a function like DATE(), meaning YOURDATE()
which can return you a valid date.

Thanks

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard ECUYER
Sent: Thursday, January 05, 2006 9:02 AM
To: Midrange Systems Technical Discussion
Subject: Re: date data types, formatting in STRSQL

You can use F13 and change the session attibutes to show date in *iso
format.
In a format with 2 digits for the year, the range is from 01/01/40 to
31/12/39 other dates are invalids...

----- Original Message ----- 
From: "rick baird" <rick.baird@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, January 05, 2006 4:38 PM
Subject: date data types, formatting in STRSQL


> Hey all,
>
> Is there any way to change the way date data types are formated when
> displayed in a STRSQL session?
>
> I tried:
> SELECT mydatefield from myfile
> and
> SELECT DATE(mydatefield) from myfile
> and
> SELECT CAST(mydatefield as date) from myfile
>
> all three show the date as mm/dd/yy.
>
> STRSQL DATFMT(*ISO) DATSEP('-') has no effect on the above.
>
> SET OPTION DATFMT=*ISO is not allowed outside of a REXX or other
> imbedded sql HLL.
>
> what am I missing here?  the problem is I have dates that are lower
> than 1935, (or whatever the cutoff date is) and they're showing up as
> ++++++++
>
> I get a data mapping error on those dates when I run it with debug on.
>
> thanks,
>
> Rick
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>