[jira] [Comment Edited] (CALCITE-5360) Implement BigQuery TIMESTAMP_ADD and TIMESTAMP_DIFF

["Julian Hyde (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-5360?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17627310#comment-17627310 ] 

Julian Hyde edited comment on CALCITE-5360 at 11/2/22 11:26 PM:
----------------------------------------------------------------

I'm doing some work on that code in CALCITE-5155 (e.g. I refactored the constructor of {{SqlTimestampAddFunction}}) so check with me before starting work on this.


was (Author: julianhyde):
I'm doing some work on that code in CALITE-5155 (e.g. I refactored the constructor of {{SqlTimestampAddFunction}}) so check with me before starting work on this.

> Implement BigQuery TIMESTAMP_ADD and TIMESTAMP_DIFF
> ---------------------------------------------------
>
>                 Key: CALCITE-5360
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5360
>             Project: Calcite
>          Issue Type: Sub-task
>          Components: core
>            Reporter: TJ Banghart
>            Priority: Major
>
> Calcite already supports TIMESTAMPADD and TIMESTAMPDIFF. We should try mapping the BQ style syntax to these already implemented functions.
> We did something similar for TIMESTAMP_TRUNC and TIME_TRUNC which conveniently mapped to FLOOR in [CALCITE-5269|https://issues.apache.org/jira/browse/CALCITE-5269]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)