[
https://issues.apache.org/jira/browse/CALCITE-2831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16761356#comment-16761356
]
Siddharth Teotia commented on CALCITE-2831:
-------------------------------------------
[~julianhyde], [~zabetak], basically the problem (already fixed in our fork) is
that extraction of hours, mins, seconds from date was not working correctly.
This was on Calcite 1.16 and looks like it is already fixed on master as part
of commits
[https://github.com/apache/calcite/commit/a9d6cfdfdce908b31a4361ac0460b83548d0fd4b]
and
[https://github.com/apache/calcite/commit/03b7af4863359dd3bb0a4c84eb01d0e39f865cf6]
We can close this bug. Also, CALCITE-2818 has a similar issue but that is
around using timestamp older than epoch so I believe it is different from this
one.
> Fix EXTRACT(SECOND FROM <DATE>)
> -------------------------------
>
> Key: CALCITE-2831
> URL: https://issues.apache.org/jira/browse/CALCITE-2831
> Project: Calcite
> Issue Type: Bug
> Reporter: Siddharth Teotia
> Assignee: Julian Hyde
> Priority: Minor
>
> Fix the EXTRACT implementation to convert a DATE value from a number of days
> to a number of milliseconds, before performing the modulo operation when
> extracting time components.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
