Subject Re: Timestamp fractional seconds
Author Roman Rokytskyy
Hi,

> How can it be, that iSQL delivers the full timestamp (with
> fractional seconds) and the pure java solution can't do it? I
> thought, that they share same communication.

Most likely your iSQL has SQL DIALECT 1, while driver has 3. Also,
driver and iSQL do not share the same communication part, they only
talk the same protocol (isql via gds32.dll, jdbc driver using plain
socket).

> Let me ask a more precice question: Can this issue be solved in
> java code or not?

If you want to use TIMESTAMP column definition - no. Right now driver
does not support SQL dialect 1. If you can switch to NUMERIC(18,0)
column definition, you can store timestamps as milliseconds since 1-
jan-1970 (value returned by System.currentTimeMillis()).

Hope this helps.

Best regards,
Roman Rokytskyy