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

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 29 Mar 2012 11:32:17 -0400
Message-ID: <CAGurbTOwu9Avc9DLBO2aK+-R+nP5pjF4EDnSPWNTmy8kDWs7dA_at_mail.gmail.com>

is your NLS_DATE_FORMAT set to YYYY-MM-DD or YYYY-DD-MM (I can't figure out since 12-10 and 10-12 are both valid dates) ? if not, then you have a problem that needs to be fixed.

On Thu, Mar 29, 2012 at 11:25 AM, jose soares <jose.soares_at_sferacarta.com>wrote:

> 'UPDATE unita_aziendale SET ts_ultima_modifica=CURRENT_TIMESTAMP,
> data_inizio=:data_inizio WHERE unita_aziendale.id = :unita_aziendale_id'
> {'data_inizio': u'1996-12-10', 'unita_aziendale_id': 319}
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 29 2012 - 10:32:17 CDT