Re: ORA-01861: literal does not match format string

From: <>
Date: Tue, 10 Feb 2009 15:16:25 +0100
Message-ID: <>

On Tue, 10 Feb 2009 06:05:58 -0800 (PST), wrote:

>We cannt chnage the java code immediately to use to_date.
>so how to avoid such error:?

The obvious solution is to change NLS_DATE_FORMAT to the correct mask by using an AFTER LOGON trigger.

However, when this mask isn't the mask you are using everywhere, this won't work flawlessly either.

You seem just to have learned how NOT to develop an application: NEVER rely on a default date format!!!!

Sybrand Bakker
Senior Oracle DBA
Received on Tue Feb 10 2009 - 08:16:25 CST

Original text of this message