Re: Full YYYY dates

[David Dawes Stanley <stanledd@SNYONEVA.CC.ONEONTA.EDU>]

Im running on an Alpha with VMS with Oracle as my DB. If you are using
Oracle, this should work. Check your code to make sure that you aren't
changing the format elsewhere. I place this code in the BEGIN-SETUP section
of my program. You might search on TO_DATE and TO_CHAR in your code to see
if your date is changed there. Hope this is of some help.
I.e.
BEGIN-SETUP
BEGIN-SQL
ALTER SESSION SET NLS_DATE_FROMAT='DD-MON-YYYY'
END-SQL
END-SETUP

NOTE: This most likely won't work for people soft, they have some other
things going on with their date stuff.

David Dawes Stanley
Lead Programmer Analysis/Web Master
SUNY SICAS Center
http://sicas.suny.edu/
http://www.oneonta.edu/~stanley  > -----Original Message-----

> From: Discussion of SQR, SQRIBE Technologies's database reporting
> language [mailto:SQR-USERS@list.iex.net]On Behalf Of Charlie Dornbos
> Sent: Monday, October 26, 1998 7:02 PM
> To: Multiple recipients of list SQR-USERS
> 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?
>