Re: timestamp with time zone wire format

From: Philippe Marschall <pm(at)netcetera(dot)ch>
To: <pgsql-jdbc(at)postgresql(dot)org>
Cc: Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
Subject: Re: timestamp with time zone wire format
Date: 2015-12-15 08:01:35
Message-ID: 566FC8DF.3010705@netcetera.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 14.12.15 14:43, Vladimir Sitnikov wrote:
>> I can write parse code
>
> Parse code for timestampTZ is probably there. The missing part is
> conversion from-to JSR-310.

The only thing I could find is TimestampUtils#toTimestampBin [1] there
the time zone either comes from the caller or the system default, never
the database. Form reading the docs I get the impression the time zone
isn't stored so there's nothing to parse.

>> for backwards compatibility with older Java/JDBC versions a dedicated class would probably be better
>
> Things will get much easier after
> https://github.com/pgjdbc/pgjdbc/pull/435 is merged in.

Is there an ETA for this?

[1]
https://github.com/pgjdbc/pgjdbc/blob/master/org/postgresql/jdbc2/TimestampUtils.java#L623

Cheers
Philippe

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Vladimir Sitnikov 2015-12-15 08:16:09 Re: timestamp with time zone wire format
Previous Message Thomas Kellerer 2015-12-15 07:52:23 Documentation bug / oversight