[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Full YYYY dates

Hi
If you are using Oracle then this should work. but if you are using
PeopleSoft, then check the setenv.sqc. This sqc also has an ALTER SESSION
command.

I am using Oracle with PeopleSoft on a Windows NT platform. In this case I
had to give the ALTER SESSION command inside the SQR also.  But the best
way is to use the "to_char"  to get  the date in whatever format you want.
It always works.






charlied@BIGNET.NET on 10/26/98 07:01:52 PM

Please respond to SQR-USERS@USA.NET

To:   SQR-USERS@list.iex.net
cc:    (bcc: C. Srinivas/dsisys/US)
Subject:  Full YYYY dates




I saw here recently someone say to get SQR to be Y2K compliant to use a
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY' within a Begin-SQL,
however SQR still only recognizes DD-Mon-YY as a valid date type. I am
using SQR 3.5, Any thoughts?