DATE_TRUNC('WEEK', PARSE_DATE_ISO8601('2023-02-27')) returns Sunday instead of Monday

Hello,
How to get ISO start of the week?
I would expect to get Monday as the result of:
select DATE_TRUNC(‘WEEK’, PARSE_DATE_ISO8601(‘2023-02-27’));

Best Regards,
Irek

Hello!

To get the day of the week, use FORMAT_DATE and use either ‘%a’ or ‘%A’ as the format parameter.

Ex:
SELECT FORMAT_DATE(‘%A’, PARSE_DATE_ISO8601(‘2023-02-27’));
–outputs ‘Monday’