Re: date data types, formatting in STRSQL

Perfect Eugen!

this was also a problem with a third party package (a web query tool)
that was having problems with those dates too.

this will work nicely, I think!

Rick

On 1/5/06, Eugen.Baum@xxxxxxx <Eugen.Baum@xxxxxxx> wrote:
>
> You can try like this
>
> select char(dateFld,ISO)
> from myFile
>
> Thank You.
>
>
>
>
>
>             rick baird
>             <rick.baird@xxxxxxx
>             om>                                                             To
>             Sent by:                    Midrange Systems Technical Discussion
>             midrange-l-bounces@         <midrange-l@xxxxxxxxxxxx>
>             midrange.com                                                    cc
>
>                                                                        Subject
>             01/05/06 10:38 AM           date data types, formatting in STRSQL
>
>
>              Please respond to
>              Midrange Systems
>                  Technical
>                 Discussion
>             <midrange-l@midrang
>                   e.com>
>
>
>
>
>
>
> 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.
>
>