Subject | Re: Timestamp fractional seconds |
---|---|
Author | Roman Rokytskyy |
Post date | 2002-10-07T14:07:22Z |
Hi,
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).
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
> How can it be, that iSQL delivers the full timestamp (withMost likely your iSQL has SQL DIALECT 1, while driver has 3. Also,
> fractional seconds) and the pure java solution can't do it? I
> thought, that they share same communication.
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 inIf you want to use TIMESTAMP column definition - no. Right now driver
> java code or not?
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