BigQuery DATE & TIME Functions|EXTRACT, TRUNC, FORMAT, PARSE
Learn how to use date and time functions in BigQuery.
Company Website: https://www.datadice.io/
Follow us:
Medium (blog posts about Google Data Analytics Release Notes, Data Studio Tips & Tricks, Introductions to Google Cloud Tools and many more): https://bit.ly/3trJPRr
LinkedIn (stay informed about most important company news): https://bit.ly/3qqJKeX
Timestamps:
2:00: CURRENT DATE and TIME
4:30: DATE
5:10: EXTRACT
7:43: TRUNC
11:39: LAST_DAY
13:29: TIMESTAMP_DIFF
15:25: TIMESTAMP_DIFF
19:06: FORMAT & PARSE TIMESTAMP