Re: Does SQR version 3.0.18.1 Y2K compliant?

[Tony DeLia <tdelia@EROLS.COM>]

Raja,
   I'm not exactly sure what you mean... I'm assuming your select
output  on the date columns is in the format 'DD-MON-YY' since you
mentioned Y2K  compliance. If you are using PeopleSoft this may be the
problem. As part of PeopleSoft's standard initialization an ALTER
SESSION command is executed setting the NLS_DATE_FORMAT. This controls
your default date formatting for the life of your SQR program. Run your
sqr using the -s parameter - look at the SQR log to find the ALTER
SESSION settings used.
For Y2K you should use 'DD-MON-YYYY' or 'YYYYMMDD'... Here's the format
of the command...

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY'

                         -Tony DeLia

PS - This is based on Oracle... Look in SETUPDB.SQC

O.R.B.Raja wrote:
>
> I have selected date values from a single column table by checking
> against my SQR input variable.
>
> It gives me different output from my PL/SQL output.
>
> my version is:
>
> SQR/3.0.18.1/Sequent/DYNIX/ptx 4.4.1/Oracle 7.3.2/Dec 03 1997
>
> Does this version support Y2K?
>
> Thanks and regards,
> Raja

--
Tony DeLia
AnswerThink Consulting Group
PeopleSoft Solutions Practice - Delphi Partners
tdelia@erols.com