Weekday Function in T-SQL

[Kayleigh]

Hi Would anyone be able to help me convert this Access function to T-SQL:
Weekday(getDate(),2)

 

[NauticalGent]

does this help?

"MySQL WEEKDAY() Function" https://www.w3schools.com/sql/func_mysql_weekday.asp

 

[Kayleigh]

No I've seen that - it only works in MySQL not SQL Server

 

[NauticalGent]

Try this then...

"How To Get Day Of Week In SQL Server? | My Tec Bits" https://www.mytecbits.com/microsoft/sql-server/get-day-of-week

 

[theDBguy]

How about?

SET DATEFIRST 1
DATEPART(weekday, GETDATE())

 

[Kayleigh]

That sounds like what I am looking for. How would I integrate it into a SELECT query?

 

[theDBguy]

That sounds like what I am looking for. How would I integrate it into a SELECT query?

If you'll always need to have Monday as the first day of the week, you'll have to execute the SET DATEFIRST command first. Otherwise, I would just suggest subtracting a 1 to the result in your query. For example:

SELECT DATEPART(weekday, GETDATE())-1

 

[Kayleigh]

So is Sunday the default?

 

[theDBguy]

So is Sunday the default?

Yes, Sunday is the default and its value is 7.