what is the difference between weekday and dayofweek function in spark SQL?

[mrvi2310]

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?

[Anonymous]

Hello, @mrvi2310​! Welcome and thanks for your question. My name is Piper and I'm one of the community moderators. Let's give it a bit to see how the other members respond. We'll circle back around if we need to.

[Hubert-Dudek]

That's correct for weekday moday=0 for dayofweek Sunday=1.​

You can also look for documentation here https://spark.apache.org/docs/latest/api/python/reference/api/pyspark.sql.functions.dayofweek.html

​https://spark.apache.org/docs/latest/api/sql/index.html

[Kaniz]

Hi @mrvi2310​ , As @Hubert Dudek​ has rightly mentioned, here are the screenshots:-

References:- https://spark.apache.org/docs/latest/api/sql/

[-werners-]

Maybe update the databricks docs, as there is indeed stated that they are synonyms.

[Kaniz]

Hi @Werner Stinckens​ , It's truly appreciated that you flagged the information here. However, as I've checked the databricks docs now, it's mentioned the same as I and @Hubert Dudek​have stated.

It states that these functions are synonyms of the function extract(DAYOFWEEK FROM expr) and are not synonyms to each other. I've attached the screenshots below.

References:- https://docs.databricks.com/sql/language-manual/functions/dayofweek.html

https://docs.databricks.com/sql/language-manual/functions/weekday.html

 

UPDATE:-

An update is required in the function WEEKDAY where it's stated that it returns an INTEGER where 1 = Sunday and 7 = Saturday.

It should have been that it returns an integer where 0 = Monday, 6 = Sunday).

[-werners-]

ah yes, my bad!

[Kaniz]

No worries!