BUG #1525: wrong time when getting timestamp from date field

Поиск
Список
Период
Сортировка
От François LECOMTE
Тема BUG #1525: wrong time when getting timestamp from date field
Дата
Msg-id 20050304103558.58F2DF1425@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #1525: wrong time when getting timestamp from date  (Kris Jurka <books@ejurka.com>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged online:

Bug reference:      1525
Logged by:          François LECOMTE
Email address:      francois.lecomte@oosphere.com
PostgreSQL version: 8.0.1
Operating system:   Linux Debian
Description:        wrong time when getting timestamp from date field
Details:

Problem when getting a Java Timestamp object on a DATE database field.
With driver pg74jdbc3.jar : hours, minutes, seconds and millis have zero
values (ex : "2003-09-10 00:00:00.0") in the Timestamp object, no problem.
With driver postgresql-8.0-310.jdbc3.jar (same database, same table, same
record) : we get 1 hour and zero minutes, seconds and millis ! ("2003-09-10
01:00:00.0")
Maybe UTC time ? but suerly a bug...

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Kelly Burkhart"
Дата:
Сообщение: BUG #1526: SHRT_MIN out of range on explicit type conversion
Следующее
От: "Al Torres"
Дата:
Сообщение: BUG #1519: server closed the connection unexpectedly