This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi,Thanks for this, just used it now… but for BigQuery.Code would
be:SELECT FLOOR((TIMESTAMP_DIFF(CURRENT_TIMESTAMP(),'1970-01-01
00:00:00',SECOND) - 60*60*(24*4 + 6))/(60*60*24*7))Hope this helps
others on BigQuery.Cheers