Message-ID: <gh-pgjdbc-pgjdbc-1325@github.com>
From: "bokken (@bokken)" <noreply+bokken@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Mon, 29 Oct 2018 18:46:53 +0000
Subject: [pgjdbc/pgjdbc] issue #1325: Additional jsr 310 support
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Assignees: bokken
X-GitHub-Author-Id: 2996845
X-GitHub-Author-Login: bokken
X-GitHub-Issue: 1325
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-State: open
X-GitHub-Type: issue
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/1325
Content-Type: text/plain; charset=utf-8

**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