public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ben Horowitz <[email protected]>
To: [email protected]
Subject: Mapping of timestamptz to TIMESTAMP vs. TIMESTAMP_WITH_TIMEZONE
Date: Fri, 17 Nov 2023 17:19:26 -0800
Message-ID: <CAM1tkGVCRayeakBXb7ZqDTuJRFup7_kiF1S4gc8-_b99Cy0i-A@mail.gmail.com> (raw)

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

[1]
https://github.com/pgjdbc/pgjdbc/blob/65f158ed8e06ffea77ca7f3b8413847817a7831f/pgjdbc/src/main/java/...

[2]
https://stackoverflow.com/questions/60451102/for-postgresql-resultsetmetadata-getcolumntype-function...

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Mapping of timestamptz to TIMESTAMP vs. TIMESTAMP_WITH_TIMEZONE
  In-Reply-To: <CAM1tkGVCRayeakBXb7ZqDTuJRFup7_kiF1S4gc8-_b99Cy0i-A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox