Re: What problems occur if I change NLS_DATE

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 09 Dec 1998 21:10:26 +0100
Message-ID: <366ED932.8CF26D22@sybrandb.demon.nl>

Any statement having date literals without an explicit to_date('date literal','mask')
will fail. This is from experience. There was a time Oracle itself changed the default date mask for the Netherlands from DD-MON-YY to DD-MM-YY. We always had date variables without masks, it was terrible. General advice: always use to_date('09-12-98','dd-mm-yy') explicitly, this will allow for both Oracle and dba's and users (not to forget) inadvertently changing their nls_date_format. Sorry to write down this horror story!

Regards,

Sybrand Bakker, Oracle DBA

A Ustby wrote:

> What problems occur if I change NLS_DATE_FORMAT?
>
> Thanks for any comments.

Received on Wed Dec 09 1998 - 14:10:26 CST

Re: What problems occur if I change NLS_DATE_FORMAT??????????????