[
https://issues.apache.org/jira/browse/CALCITE-5290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17751408#comment-17751408
]
Guillaume Massé commented on CALCITE-5290:
------------------------------------------
Apache Spark has a similar syntax:
https://spark.apache.org/docs/latest/api/sql/index.html#date_trunc. I will give
this issue a try.
> Add DATE_TRUNC function consistent with Postgres
> ------------------------------------------------
>
> Key: CALCITE-5290
> URL: https://issues.apache.org/jira/browse/CALCITE-5290
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: TJ Banghart
> Priority: Major
>
> Add {{DATE_TRUNC}} function consistent with Postgres. Per the
> [specification|https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC],
> syntax is as follows:
> {code}
> DATE_TRUNC(<string>, <timestamp | date | time>)
> {code}
> It is a different (and more complex) specification than BigQuery's DATE_TRUNC
> (see CALCITE-5180), which has the following syntax:
> {code}
> DATE_TRUNC(<date>, <interval>)
> {code}
> Postgres DATE_TRUNC would be implemented after CALCITE-5155 and would allow
> user-defined time frames in the {{field}} argument.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
