Re: date data types, formatting in STRSQL

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.