Re: Setting SQR_DB_DATE_FORMAT

[Joe Johnson <jej1216@HOTMAIL.COM>]

Allan,

We had some SQR's that had the YY year format -- worked fine during 1999, as
Oracle would assume the current century and make '99'to '1999'.

But, in year 2000, Oracle used the same logic and turned '99' to '2099'.

We had to change the date mask in our SQR to 'RR' for the year, and then
Oracle made any entry over '50' to be '19XX' and any number under '50' to be
'20XX.'

HTH

Joe Johnson ;{)
Free and Cheap Stuff on the Web
http://www.userworld.com/users/jejohn/Index.html
----- Original Message -----
From: Allan Geetter <geetter@MAIL.HARTFORD.EDU>
To: <SQR-USERS@list.iex.net>
Sent: Wednesday, April 12, 2000 10:32 AM
Subject: Setting SQR_DB_DATE_FORMAT


> INPUT DATE statement in text format:  DD-MON-YYYY.
>
> SQR will accept a 2 character year but when program run and date is
> being reformatted to YYYY, incorrect century appears - e.g. 01-JUL-99
> entered, result is 01-JUL-2099.
>
> Oracle database being used.
>
> Running SQR VER 4.2.1
>
> Program aborts with SQR 1944 - The date is not in the format specified
> by SQR_DB_DATE_FORMAT or in one of the accepted formats.
>
> Is the SQR_DB_DATE_FORMAT set in the server SQR.INI file and if so how
> and where.
>
> Any help would be greatly appreciated.
>
> Allan Geetter
> University of Hartford
> E-Mail:geetter@mail.hartford.edu
>
>
> --
> Allan
> Geetter
> Phone: (860) 768-4889
> Data Security Administrator                                    FAX:
> (860) 768-4907
> University of Hartford
> E-Mail:geetter@mail.hartford.edu
> Information Technology Services - CC125
> 200 Bloomfield Avenue
> West Hartford, CT 06117
>