DATE_DIFF Syntax in Google Bigquery
Use the DATE DIFF function to subtract two days and get the difference
SELECT DATE_DIFF(DATE '2010-07-07', DATE '2008-12-25', DAY) as days_diff;
You can also get the difference in,
- WEEK This date part begins on Sunday
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds