Here's what the oracle manual has to say:
ORA-01861 literal does not match format string
Cause: Literals in the input must be the same length as literals in the format
string (with the exception of leading white space). If the "FX" modifier has
been toggled on, the literal must match exactly, with no extra white space.
Action: Correct the format string to match the literal.
I suppose it would be helpful to see the sql or whatever you are using to try
to input that string.
--- RBonazzo <[EMAIL PROTECTED]> wrote:
> Hi,
> maybe try this format "05-16-2001 10:10:10"
> regards
> Rinaldo
> [EMAIL PROTECTED]
>
> -----Messaggio originale-----
> Da: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]Per conto di
> Albert Yip
> Inviato: mercoled� 16 maggio 2001 16.42
> A: [EMAIL PROTECTED]
> Oggetto: Prepared Statement and date
>
>
> Hi all,
>
> Just wondering about how should I deal with dates when trying to insert data
> into db with prepared statements. I tried to use strings like "2001-05-16
> 10:10:10" but it keeps giving me error:
>
> java.sql.SQLException: ORA-01861: literal does not match format string
>
> any ideas? I would really appreciate it if someone can give a hand.
>
> Thanks,
> Albert
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
