Google BigQuery Date Functions

Publicado em: 03 Julho 2022
no canal de: Analytics with Adam

6,003

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...

Nesta página do site você pode assistir ao vídeo on-line Google BigQuery Date Functions duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Analytics with Adam 03 Julho 2022, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 6,003 vezes e gostou 56 espectadores. Boa visualização!

32,005

896

00:00:00