Subject Re: [Firebird-Java] Date/Time with Prepared Statement
Author Thomas Steinmaurer
>> 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?
>
> the setTimestamp in combination with java.sql.Timestamp.valueOf(...),
> but you have to ensure the yyyy-mm-dd hh:mm:ss.fffffffff format of the
> string (I think fraction seconds can be omitted).

Hmm, ok.

How to do that, if I don't have one TIMESTAMP field, but a DATE and a
TIME field?

I'm sorry, a Delphi guy is a bit confused regarding handling date/time
in Java. ;-)


Thanks!

Thomas