Open
Description
Java 8 time types are more modern and should be preferred over the old types Date, Time, etc.
java.time.LocalDatejava.time.LocalTimejava.time.LocalDateTimejava.time.OffsetDateTimejava.time.ZonedDateTimejava.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.