Hi!
My database contains a table which contains a java.sql.TIMESTAMP column. I 
found in the h2 databse source the ValueTimestamp.parse(String) function 
and so I tried to set the value of that column bei an ISO 8601 String 
"2012-11-08T12:40:11.156Z".
I was able to insert the row without any exception but in my opinion is the 
parsed value not correct.


org.h2.value.ValueTimestamp.parse("2012-11-08T12:40:11.156Z").getDate()
--> internal java.util.Date.fasttime: 1352329200000

DatatypeFactory.newInstance().newXMLGregorianCalendar("2012-11-08T12:40:11.156Z").toGregorianCalendar().getTime()
--> internal java.util.Date.fasttime: 1352378411156

Am I doing something wrong? Or will this bug fixed by the planned change  
"Support 
date/time/timestamp as documented in http://en.wikipedia.org/wiki/ISO860";

Best Regards,
Steve



-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/Mo89yOCxVsAJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to