[jira] [Commented] (CALCITE-5357) Implement BigQuery FORMAT_TIMESTAMP/DATE

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

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

Julian Hyde commented on CALCITE-5357:
--------------------------------------

Something to ponder as you're working on this. A few of the timestamp functions convert a date into years/months/days several times (for example, {{SqlFunctions.lastDay(long)}} calls {{DateTimeUtils.unixDateExtract}} for both YEAR and MONTH). I can imagine that {{FORMAT_TIMESTAMP}} would have to do something similar. It's not terrible, but it's a bit inefficient. If you can think of a way to amortize the effort, and please log a Jira case with a proposal.

> Implement BigQuery FORMAT_TIMESTAMP/DATE
> ----------------------------------------
>
>                 Key: CALCITE-5357
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5357
>             Project: Calcite
>          Issue Type: Sub-task
>          Components: core
>            Reporter: TJ Banghart
>            Assignee: TJ Banghart
>            Priority: Major
>




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