weekday snowflake in number

1YEAR( <date_or_timestamp_expr> )
2
3YEAROFWEEK( <date_or_timestamp_expr> )
4YEAROFWEEKISO( <date_or_timestamp_expr> )
5
6DAY( <date_or_timestamp_expr> )
7
8DAYOFMONTH( <date_or_timestamp_expr> )
9DAYOFWEEK( <date_or_timestamp_expr> )
10DAYOFWEEKISO( <date_or_timestamp_expr> )
11DAYOFYEAR( <date_or_timestamp_expr> )
12
13WEEK( <date_or_timestamp_expr> )
14
15WEEKOFYEAR( <date_or_timestamp_expr> )
16WEEKISO( <date_or_timestamp_expr> )
17
18MONTH( <date_or_timestamp_expr> )
19
20QUARTER( <date_or_timestamp_expr> )
21