TIMESTAMP value binary transfer problem
От | Vladimir Crnčić (Infoart d.o.o.) |
---|---|
Тема | TIMESTAMP value binary transfer problem |
Дата | |
Msg-id | 001401cfedf0$2d861690$889243b0$@infoart.hr обсуждение исходный текст |
Ответы |
Re: TIMESTAMP value binary transfer problem
|
Список | pgsql-jdbc |
There is a problem with JDBS driver interpretation of "timestamp without time zone" values when binary transfer is on. When binary transfer is disabled for TIMESTAMP columns (binaryTransferDisable=TIMESTAMP or binaryTransfer=false) problem does not occur.
database version: 9.1.1
driver version: 9.2, 9.3
BINARY TRANSFER:
----------------
database value (TIMESTAMP): 2014-10-26 01:00:04
bytes (AbstractJdbc2Resultset): [0, 1, -87, 71, -77, -6, 45, 0]
long value (TimestampUtils): 467600404000000
java timestamp (TimestampUtils): 2014-10-26 02:00:04.0 (not OK)
TEXT TRANSFER:
--------------
database value (TIMESTAMP): 2014-10-26 01:00:04
string value (AbstractJdbc2Resultset): 2014-10-26 01:00:04
java timestamp (TimestampUtils): 2014-10-26 01:00:04.0 (OK)
В списке pgsql-jdbc по дате отправления: