Return day number for the date passed

Question

How can we find the day number for a date passed. Say, if it is 'Sunday', then 1, 'Monday', then 2 and so on. Is there any in built function for this other than user defined functions?

Please have some date type queries and check samples. if getting struck somewhere, provide the queries used and their bottlenecks — NitinSingh, Jul 16 '18 at 06:44
https://stackoverflow.com/questions/1110998/get-day-of-week-in-sql-2005-2008 — NitinSingh, Jul 16 '18 at 06:46

score 2 · Answer 1 · answered Jul 16 '18 at 06:40

2

SQL Server builtin function DATEPART() takes two parameters and can do what you are trying to do.

SELECT DATEPART(DW , GETDATE() -1)   -- Returns 1 for sunday.

Also depending on what you pass to the 1st parameters in the function, it can return different parts of the date value passed in the second parameter.

answered Jul 16 '18 at 06:40

M.Ali

67,945
13
101
127

Actually, this one returns 1 for Monday. You could avoid the `-1` part right? – AswinRajaram Jul 16 '18 at 06:44
@AsRa I have used `-1` is to get Sunday's date not to get 1, I have passed GETDATE() which will pass the function today's date, I wanted to passed the functino Sunday's date. – M.Ali Jul 16 '18 at 06:45

score 1 · Accepted Answer · answered Jul 16 '18 at 06:41

1

You can use the function DAYOFWEEK. The format is:

 SELECT{fn DAYOFWEEK(GETDATE())}

Alternate method:

 SELECT DATEPART(WEEKDAY,GETDATE())

answered Jul 16 '18 at 06:41

AswinRajaram

1,519
7
18

Return day number for the date passed

2 Answers2