Bernt M. Johnsen wrote:
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
so any other format like mm/dd/yyyy hh:mm:ss for example will not be
inserted right ???
or is it a way to avoid this problem ?
Thanks
Thank you
Nicolas Dufour
