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,
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’