[
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)
