SNOW-1723202: Support Java 8 java.time types

[DenWav]

Java 8 time types are more modern and should be preferred over the old types Date, Time, etc.

• java.time.LocalDate
• java.time.LocalTime
• java.time.LocalDateTime
• java.time.OffsetDateTime
• java.time.ZonedDateTime
• java.time.Instant

The Snowflake documentation specifies:

Although Snowflake can store time values with nanosecond precision, the java.sql.time library maintains only millisecond precision. Conversion between Snowflake and Java data types can reduce effective precision to milliseconds.

This limitation is not present in the modern java.time types, and time zone information is explicit, rather than implicit and prone to error.

Note that proper implementation of this would not involve converting from the old Java types to the new ones, since that would not fix the issue described here.

[sfc-gh-dszmolka]

hi - i'm wondering this could be a little bit of duplicate of snowflakedb/snowflake-jdbc#1494 for the underlying Snowflake JDBC driver ?
Can you please check ?