Re: Oracle 8.0.5 and Date formats

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Tue, 2 Mar 1999 22:59:37 +0100
Message-ID: <36dc5f51$0$10415@pascal>

Jason Lee wrote
>How does one go
>about getting Oracle to accept a date in a yyyy-mm-dd format
>permanently?

Permanently? You cannot, as any user setting overrides the server setting. One could set NLS_DATE_FORMAT on the server (any Unix user might simply override it in .profile) but an ALTER SESSION would be the only fool proof option I guess.

Note that the factory default date format uses MON, not MONTH, which implies that Oracle would expect JUL, not JULY like you typed. However, as Oracle uses some logic to try other formats when the given one fails, July is bound to be accepted as well.

Arjan. Received on Tue Mar 02 1999 - 15:59:37 CST