> Hello
>
> I have a request like
> insert into toolbox
> (idtoolbox,label,descr,language,idlinktype,idsource,creatingdate,updatingdat
> e,publish,delstatus,orderby) values (2,'services et
> catégories','','FR',0,0,to_date('2004-07-19 00:00:00.0',
> 'dd/mm/yyyy'),to_date('2004-07-19 00:00:00.0', 'dd/mm/yyyy'),1,0,9999)
>
<snip>
> I obtain this error
>
> Error Executing Database Query.
> [Macromedia][Oracle JDBC Driver][Oracle]ORA-01861: literal does not match
> format string
<snip>
I may be wrong but try taking out the time string from the date and
also ensuring that the format of the date matches ie:
to_date('19/07/2004', 'dd/mm/yyyy')
HTH
Simon
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
