Function dayOfWeek()
calculates the day of week of a time value and returns that integer, where 1 stands for Sunday, 2 stands for Monday, 3 stands for Tuesday, and so on.
Arguments:
- Time <datetime | timestamp | string>
Returns:
- Day of week <number>
Common Usage
Example: Calculate day of week of each row of an alias
uncollect ["2023-04-30 22:30:35", "2020-01-15 09:03:16"] as a
return dayOfWeek(a)
1
4