You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Gregory Hart (Jira)" <ji...@apache.org> on 2022/12/02 01:17:00 UTC

[jira] [Created] (CALCITE-5414) Use DateTimeUtils to correctly convert between java.sql types and unix timestamps

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)