Gregory Hart created CALCITE-5414:
-------------------------------------
Summary: Use DateTimeUtils to correctly convert between java.sql
types and unix timestamps
Key: CALCITE-5414
URL: https://issues.apache.org/jira/browse/CALCITE-5414
Project: Calcite
Issue Type: Bug
Components: core
Reporter: Gregory Hart
Assignee: Gregory Hart
Converting java.sql types to unix timestamps requires extra steps to also
convert to the correct calendar. Unix timestamps should follow the proleptic
Gregorian calendar as defined by ISO-8601. Java uses the standard Gregorian
calendar for java.sql types and switches to the Julian calendar for dates
before the Gregorian shift.
The DateTimeUtils class in Avatica correctly handles the calendar conversions.
Calcite should use those methods since its own methods do not currently convert
between calendars.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
