OraFAQ Forum: Server Administration » Date format - is it possible to bypass it using settings ?

Home » RDBMS Server » Server Administration » Date format - is it possible to bypass it using settings ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Date format - is it possible to bypass it using settings ? [message #50316]

Mon, 11 March 2002 05:11

Andrei Zykov
Messages: 1
Registered: March 2002

Junior Member

Hi all,

I have a SliverStream application initially written for MS SQL 7, that constructs SQL queries programmatically, particularly, data strings are coded as "YYYY-MM-DD".
However, due to different date format on Oracle 8i ("DD-MON-RR"), queries using date fields in WHERE clause cause errors.
Is it possible to configure Oracle database so that without making changes in the app's code queries could be run correctly ? (The database is exclusively used by this application).
I changed NLS_DATE_FORMAT in initial parameter file accordingly, but this did not help. It seems that changing this parameter at session level (ALTER SESSION..) could help, but this is inacceptable due to some reasons.

Thank you.

Report message to a moderator

Re: Date format - is it possible to bypass it using settings ? [message #50339 is a reply to message #50316]

Tue, 12 March 2002 00:17

Viks
Messages: 4
Registered: March 2002

Junior Member

Try to change registry setting on client side.

REGEDIT4

[[HKEY_LOCAL_MACHINESOFTWAREORACLE]]
"NLS_DATE_FORMAT"="YYYY-MM-DD"

SQL> select sysdate from dual;

SYSDATE
---------
12-MAR-02

After change in registry.

SQL> select sysdate from dual;
SYSDATE
----------
2002-03-12

Report message to a moderator

Previous Topic:	ORA-24323 Value not allowed
Next Topic:	Index usage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 21:02:32 CST 2024