Subject Date/Time with Prepared Statement
Author Thomas Steinmaurer
Hello,

I get a date and a time value from a XML file as a string.

e.g. 2007-12-31 and 12:34:23

Both values can be inserted into a dialect 3 database with a DATE and
TIME field by using the .setString(...) method for a PreparedStatement.

This works fine. But now I also want to handle the millisecond time
information somehow (e.g. with a string 12:34:23.2345), but I don't see
the obvious thing how to that with JDBC.

What's the best way to handle date and time (incl. ms information) when
the come along as a string with JayBird/JDBC?


Thanks!

Thomas