You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Chris Baynes (JIRA)" <ji...@apache.org> on 2017/05/21 13:55:04 UTC
[jira] [Created] (CALCITE-1798) Jdbc dialect specific datetime
floor operators
Chris Baynes created CALCITE-1798:
-------------------------------------
Summary: Jdbc dialect specific datetime floor operators
Key: CALCITE-1798
URL: https://issues.apache.org/jira/browse/CALCITE-1798
Project: Calcite
Issue Type: Bug
Reporter: Chris Baynes
Assignee: Julian Hyde
The FLOOR operator (on dates) is currently broken for all jdbc dialects.
The syntax allowed by the parser looks like: "FLOOR(datetime to timeUnit)".
However no jdbc dialect (as far as I'm aware) actually name the function FLOOR:
In postgres: DATE_TRUNC('year', my_datetime)
In hsqldb: TRUNC ( my_datetime, 'YYYY' )
In oracle: TRUNC(my_datetime, 'YEAR')
In mysql: There's no direct equivalent in mysql (though it could be emulated with some nasty timestamp diffing)
The other issue is that the timeUnits are sometimes also named differently by each dialect (e.g. 'YYYY' in hsqldb).
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)