what is the difference between weekday and dayofweek function in spark SQL?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-10-2021 03:20 PM
dayofweek: https://docs.databricks.com/sql/language-manual/functions/dayofweek.html
weekday : https://docs.databricks.com/sql/language-manual/functions/weekday.html
According to the documentation , they both are synonym functions.
But when I use it I noticed that weekday starts the day count from Tuesday = 1
Would this be considered a bug or do both functions mean different things?
Labels:
- Labels:
-
Databricks SQL
-
SQL