AW: date data types, formatting in STRSQL

["Hauser, Birgitta" <Birgitta.Hauser@xxxxxxxxxxx>]

Hi Rick,

Change date format in STRSQL by using funktion key F13 and option 1.

Birgitta 

"If you think education is expensive, try ignorance"
(Derek Bok)

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von rick baird
Gesendet: Donnerstag, 5. Januar 2006 16:39
An: Midrange Systems Technical Discussion
Betreff: 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