There are two ways of doing this: One based on the name of the day of the week, the other based on the weekday number. SELECT ID, Name, Salary, Date FROM <table_name> WHERE DATENAME(WEEKDAY, Date) IN ('Saturday', 'Sunday'); Alternatively, you can use DATEPART(WEEKDAY, Date) .
Moreover, how do I get Saturday and Sunday of the month in SQL?
- set @startDate='01/01/2012'
- set @enddate='12/31/2012'
- while @startDate<=@enddate.
- begin.
- if(DATENAME(dw,@startDate)='Sunday' or DATENAME(dw,@startDate)='Saturday')
- insert into MyHoliday(Holiday_date,Specification) values(convert(date,@startDate,103),DATENAME(dw,@startDate))
- set @startDate=DATEADD(DD,1,@startDate)
Subsequently, question is, how do I get the current week Sunday date in SQL? Divide Week_Start_Date select statement
- select DATEPART(WEEKDAY, GETDATE())
- select CAST(GETDATE() AS DATE)
- SELECT DATEADD(DAY, 2 - 5, '2017-04-06') [Week_Start_Date]
In respect to this, how do I find weekends in SQL?
SELECT ID, Name, Salary, Date FROM <table_name> WHERE DATENAME(WEEKDAY, Date) IN ('Saturday', 'Sunday'); Alternatively, you can use DATEPART(WEEKDAY, Date) .
How do I skip weekends in SQL?
If you want to only exclude Sunday and it is the first day of the week for your server, SELECT [date_created] FROM table. WHEREDATEPART(w,[date_created]) NOT IN (1)
For excluding weekend data we need to write the query as:
- SELECT *
- FROM table.
- WHERE ((DATEPART(dw, CheckedInDate) + @@DATEFIRST) % 7) NOT IN (0, 1)
