db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: Derby dates
Date Mon, 26 Sep 2005 13:44:14 GMT
>>>>>>>>>>>> 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

Mime
View raw message