Google BigQuery Date Functions
This video will cover some Google BigQuery SQL Date Functions for beginners. The BigQuery SQL Date Functions we will cover are the following.
1. The date_diff function, which allows the user to extract the difference between two dates in SQL measure in a selected date part, in the video we look at day, month and hour, for a full list of date parts please refer to the BigQuery SQL Date Functions documentation which we have a link to below.
The date difference function needs to be formatted as date_diff(later date col, earlier date col, date part)
2. The extract function can extract a part of a date to be used for analytics / aggregation. The extract function needs to be formatted as extract(date part from date column)
3. The last day function converts a date to the last day of the month it occurs in, perfect for aggregating values.
4. The format date function formats the date in to different date formats. FORMAT_DATE("%x", date)
You can find the date function documentation here https://cloud.google.com/bigquery/doc....
You can find the date format documentation here
https://cloud.google.com/bigquery/doc...