[ https://issues.apache.org/jira/browse/CALCITE-5414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gregory Hart updated CALCITE-5414: ---------------------------------- Labels: pull-requests-available (was: pull-request-available) > 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 > Priority: Major > Labels: pull-requests-available > Time Spent: 10m > Remaining Estimate: 0h > > 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)