[CALCITE-5447] Add DATE_TRUNC for BigQuery

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.33.0
• Labels: pull-request-available
• Assignee: Oliver Lee
• Reporter: Oliver Lee
• Created: 20/Dec/22 01:10
• Updated: 08/Mar/23 17:26
• Resolved: 14/Jan/23 01:12

Description

Adding in BigQuery's definition of DATE_TRUNC as described https://g3doc.corp.google.com/company/teams/googlesql/reference/date_functions.md?cl=head#date-trunc

 

ex.

DATE_TRUNC('2022-01-05', month) -> 2022-01-01

DATE_TRUNC('2022-01-05', day) -> 2022-01-05

DATE_TRUNC('2022-01-05', year) -> 2022-01-01

 

 

Supported parameters:

• DAY
• WEEK
• WEEK(WEEKDAY)following: SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, or SATURDAY.
• ISOWEEK
• MONTH
• QUARTER
• YEAR
• ISOYEAR

 

Issue Links

• is a child of: CALCITE-5180 Implement BigQuery functions for DATE, TIME, TIMESTAMP, DATETIME
• is a parent of: CALCITE-5450 Add support for WEEK(WEEKDAY) for custom time frames to relevant functions
• relates to: CALCITE-5290 Add DATE_TRUNC function consistent with Postgres
• links to: GitHub Pull Request #3009