Thread: [pgjdbc/pgjdbc] 138d58: Ms goodman time gettimestamp micros (#2181)

[pgjdbc/pgjdbc] 138d58: Ms goodman time gettimestamp micros (#2181)

From
Dave Cramer
Date:
  Branch: refs/heads/master
  Home:   https://github.com/pgjdbc/pgjdbc
  Commit: 138d589592babba2a14cb6c6db8dc6f9a159495f
      https://github.com/pgjdbc/pgjdbc/commit/138d589592babba2a14cb6c6db8dc6f9a159495f
  Author: Dave Cramer <davecramer@gmail.com>
  Date:   2021-11-15 (Mon, 15 Nov 2021)

  Changed paths:
    M pgjdbc/src/main/java/org/postgresql/jdbc/PgResultSet.java
    M pgjdbc/src/main/java/org/postgresql/jdbc/TimestampUtils.java
    M pgjdbc/src/test/java/org/postgresql/test/jdbc2/TimestampTest.java

  Log Message:
  -----------
  Ms goodman time gettimestamp micros (#2181)

* fix: add microsecond precision to getTimestamp() called on sql TIME(6)

Currently, "when fetching a value of type TIME(6) through
resultSet.getTimestamp() only ms precision is retained, the microsecond
fractional digits are lost." This change will retain the microsecond
precision when .getTimestamp() is called on TIME(6).

Closes #1537

* add handling for binary representation of timetz, add to timezonetest

* make toTimestampBin arguments nullable

* Correct getTime when type is DATE

* fix: add microsecond precision to getTimestamp() called on sql TIME(6)

Co-authored-by: Mike Goodman <msgoodman90@gmail.com>