如果在BigQuery中一周从星期一开始，如何获得当前一周的第一天?

Question

SELECT TIMESTAMP_TRUNC(CURRENT_DATE(), WEEK(MONDAY)) AS FirstDayOfWeek

我是大查询的初学者。上面的查询给了我一个错误，请帮助我纠正这个错误。

错误信息:

No matching signature for function TIMESTAMP_TRUNC for argument types: DATE, DATE_TIME_PART. Supported signature: TIMESTAMP_TRUNC(TIMESTAMP, DATE_TIME_PART, [STRING]) at [1:8]

Answer 1

用DATE_TRUNC代替TIMESTAMP_TRUNC

SELECT DATE_TRUNC(CURRENT_DATE(), WEEK(MONDAY)) AS FirstDayOfWeek