Re: date data types, formatting in STRSQL

That's it Richard.  Thanks a ton.

On 1/5/06, Richard ECUYER <recuyer@xxxxxxx> wrote:
> 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.
> >
> >
>
> --
> 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.
>
>