You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Tanner Clary (Jira)" <ji...@apache.org> on 2023/01/17 16:49:00 UTC
[jira] [Assigned] (CALCITE-5484) Implement BigQuery DATETIME_SUB
[ https://issues.apache.org/jira/browse/CALCITE-5484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tanner Clary reassigned CALCITE-5484:
-------------------------------------
Assignee: Tanner Clary
> Implement BigQuery DATETIME_SUB
> -------------------------------
>
> Key: CALCITE-5484
> URL: https://issues.apache.org/jira/browse/CALCITE-5484
> Project: Calcite
> Issue Type: Sub-task
> Reporter: Tanner Clary
> Assignee: Tanner Clary
> Priority: Major
>
> BigQuery's {{DATETIME_SUB(timestamp, interval)}} returns the timestamp that occurs {{interval}} before {{timestamp}}.
> Example: {{DATETIME_SUB(TIMESTAMP '2008-12-25 15:30:00', INTERVAL 5 MINUTE)}} would return: '2008-12-25 15:25:00'.
> [BigQuery docs|https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime_sub]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)