pgjdbc/pgjdbc GitHub issues and pull requests (mirror)  

help / color / mirror / Atom feed

From: bokken (@bokken) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: [pgjdbc/pgjdbc] issue #1325: Additional jsr 310 support
Date: Mon, 29 Oct 2018 18:46:53 +0000
Message-ID: <[email protected]> (raw)

**I'm submitting a ...**

  <!--- What kind of an issue is this? Put an `x` in all the boxes that apply: -->
- [ ] bug report
- [x ] feature request
    

**Describe the issue**
Additional support for jsr 310 data types

**Java Version**
1.8

**OS Version**
N/A

**PostgreSQL Version**
All

**To Reproduce**
N/A

**Expected behaviour**
ResultSet.getObject(Class) should have following behaviors:
For TIMESTAMP and TIMESTAMPTZ:

Instant should be supported for TIMESTAMP and TIMESTAMPTZ

ZonedDateTime
  For TIMESTAMP, the local default ZoneID should be used.
  For TIMESTAMPTZ, UTC should be used

OffsetDateTime, LocalDateTime, LocalDate and LocalTime call all be supported by calling the relevant to* methods on ZonedDateTime.

For DATE:

java.sql.Date and LocalDate should be supported (existing behavior)

For TIME
java.sql.Time and LocalTime should be supported (existing behavior)

PreparedStatement.setObject(Object, int) should have the following behaviors:
For Type TIMESTAMP and TIMESTAMP_WITH_TIMEZONE objects of following type should be supported:
Instant, OffsetDateTime, ZonedDateTime, LocalDateTime.

PreparedStatement.setObject(Object) should add the following objects:
Instant (same as a Timestamp)
ZonedDateTime same as OffsetDateTime (using toOffsetDateTime conversion).


**Logs**
N/A

view thread (25+ 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: github://pgjdbc/pgjdbc
  Cc: [email protected], [email protected]
  Subject: Re: [pgjdbc/pgjdbc] issue #1325: Additional jsr 310 support
  In-Reply-To: <<[email protected]>>

* 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