Re: Setting SQR_DB_DATE_FORMAT

["Salem, Mark" <MSalem@MSA.COM>]

Try the following in your SQR.ini:


[Environment:Oracle]

SQR_DB_DATE_FORMAT='DD-MON-YYYY'




Also, we do the following as the first thing in Begin-Program

Do Alter_Session
...

BEGIN-PROCEDURE ALTER_SESSION
BEGIN-SQL
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY'
END-SQL
END-PROCEDURE ALTER_SESSION



> -----Original Message-----
> From: Allan Geetter
> Sent: Wednesday, April 12, 2000 11:32 AM
> To:   SQR-USERS@list.iex.net
> 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