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...
Смотрите видео Google BigQuery Date Functions онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Analytics with Adam 03 Июль 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 6,003 раз и оно понравилось 56 людям.