Mapping of timestamptz to TIMESTAMP vs. TIMESTAMP_WITH_TIMEZONE

Поиск
Список
Период
Сортировка
От Ben Horowitz
Тема Mapping of timestamptz to TIMESTAMP vs. TIMESTAMP_WITH_TIMEZONE
Дата
Msg-id CAM1tkGVCRayeakBXb7ZqDTuJRFup7_kiF1S4gc8-_b99Cy0i-A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Mapping of timestamptz to TIMESTAMP vs. TIMESTAMP_WITH_TIMEZONE
Список pgsql-jdbc
Дерево обсуждения
Hi,

Apologies if this is a duplicate of an answered question. I searched in the mailing list archives, Stack Overflow, etc., and didn't find anything.

At the line linked below in TypeInfoCache, it appears that type timestamptz is getting mapped to the type java.sql.Types.TIMESTAMP [1] . It seems like it should be mapped to java.sql.Types.TIMESTAMP_WITH_TIMEZONE.

TIMESTAMP_WITH_TIMEZONE was introduced in Java 8 (2014). Is the mapping of timestamptz to TIMESTAMP intentional for reasons of backwards compatibility?

I found the behavior surprising, and also found a question on Stack Overflow where someone else was surprised [2].

Thanks very much,
Ben


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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Connection Timeout Issue due to intermittent non-response of Postgre database
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Mapping of timestamptz to TIMESTAMP vs. TIMESTAMP_WITH_TIMEZONE