[jira] [Commented] (CALCITE-5423) Implement TIMESTAMP_DIFF function (compatible with BigQuery)

["Tanner Clary (Jira)" <ji...@apache.org>]

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

Tanner Clary commented on CALCITE-5423:
---------------------------------------

[~julianhyde] I'm taking a first look at this and just to verify my understanding- this function _should_ support custom timeframes because it does not use intervals, but just a time unit. However, the operands are still ordered differently than they are in the standard ([reference|https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_diff]). Should this difference be accounted for in SqlTimestampDiffFunction, StdConvertletTable, or perhaps both? Thanks.

> Implement TIMESTAMP_DIFF function (compatible with BigQuery)
> ------------------------------------------------------------
>
>                 Key: CALCITE-5423
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5423
>             Project: Calcite
>          Issue Type: Sub-task
>            Reporter: Julian Hyde
>            Assignee: Tanner Clary
>            Priority: Major
>
> Implement TIMESTAMP_DIFF function (compatible with BigQuery).



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