Subject | Date/Time with Prepared Statement |
---|---|
Author | Thomas Steinmaurer |
Post date | 2008-01-31T15:58:38Z |
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
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