[
https://issues.apache.org/jira/browse/CALCITE-4089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde reassigned CALCITE-4089:
------------------------------------
Assignee: Julian Hyde
> In Babel, allow 'CAST(integer AS DATE)' even though it is illegal in Calcite
> SQL
> --------------------------------------------------------------------------------
>
> Key: CALCITE-4089
> URL: https://issues.apache.org/jira/browse/CALCITE-4089
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Priority: Major
>
> In Babel, allow 'CAST(integer AS DATE)', even though it is illegal in Calcite
> SQL (and standard SQL).
> Map it to valid standard SQL. BigQuery {{CAST(n AS DATE)}} is equivalent to
> Calcite {{DATE '1970-01-01' + n * INTERVAL '1' DAY}}.
> Also, add functions {{DATE_FROM_UNIX_DATE(INTEGER)}},
> {{UNIX_SECONDS(TIMESTAMP)}}, {{UNIX_MILLIS(TIMESTAMP)}},
> {{UNIX_MICROS(TIMESTAMP)}}, {{TIMESTAMP_SECONDS(BIGINT)}},
> {{TIMESTAMP_MILLIS(BIGINT)}}, {{TIMESTAMP_MICROS(BIGINT)}} in the BigQuery
> library. They are well-named and well-specified, so they might be useful to
> people working in dialects besides BigQuery. {{DATE_FROM_UNIX_DATE(0)}}
> should return {{DATE '1970-01-01'}}.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
