Re: ORA-01861: literal does not match format string
From: <sybrandb_at_hccnet.nl>
Date: Tue, 10 Feb 2009 15:16:25 +0100
Message-ID: <1u23p4p8mljpa8hs6u7hovhlpbcp0qorfh_at_4ax.com>
On Tue, 10 Feb 2009 06:05:58 -0800 (PST), shweta.kaparwan_at_googlemail.com wrote:
Date: Tue, 10 Feb 2009 15:16:25 +0100
Message-ID: <1u23p4p8mljpa8hs6u7hovhlpbcp0qorfh_at_4ax.com>
On Tue, 10 Feb 2009 06:05:58 -0800 (PST), shweta.kaparwan_at_googlemail.com 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 DBAReceived on Tue Feb 10 2009 - 08:16:25 CST