>>>>>>>>>>>> Nicolas Dufour wrote (2005-09-26 08:16:14): > Hello > > First of all, I would thank the work behind derby : it's a really good > product :) > > Now, I have a little problem to use it with datetime. > I have this error : > > SQL Exception: The syntax of the string representation of a datetime > value is incorrect > ERROR 22007: The syntax of the string representation of a datetime value > is incorrect. > > And I think that the values are for example in this format : > 01/02/2004 00:00:00 > > I have looked at the docs, but I cant find a clear answer about this. > What is the correct datetime syntax ?
{ts 'yyyy-mm-dd hh:mm:ss.f...'}
Which should work for any conformat JDBC driver
>
> Thank you
>
> Nicolas Dufour
--
Bernt Marius Johnsen, Database Technology Group,
Sun Microsystems, Trondheim, Norway
pgpqMxsXtWbja.pgp
Description: PGP signature
