topic Re: what is the difference between weekday and dayofweek function in spark SQL? in Data Engineering

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

mrvi2310 — Fri, 10 Dec 2021 23:20:18 GMT

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?

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

Anonymous — Sat, 11 Dec 2021 00:40:50 GMT

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.

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

Hubert-Dudek — Sat, 11 Dec 2021 10:37:47 GMT

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

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

-werners- — Mon, 13 Dec 2021 11:47:57 GMT

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

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

-werners- — Mon, 13 Dec 2021 13:17:40 GMT

ah yes, my bad!