bigquery standard sql get dayofweek

Question

In Bigquery standard sql how to extract day of a week (number)?
We can do this in Legacy sql using DAYOFWEEK function but couldn't find any equivalent function in the standard sql.

Answer 1

#standardSQL
SELECT EXTRACT(DAYOFWEEK FROM CURRENT_DATE())   

see more for EXTRACT(part FROM date_expression)