|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.