#datepart

How to get week number of the month from the date in SQL server?

This is such a simple way to get the week number of the month.

declare @date date = ‘3 Nov 2019’

select convert(int, datepart(wk, @date)) – convert(int, datepart(wk, DATEFROMPARTS(YEAR(@date),MONTH(@date),1))) + 1

— return 2

  *calendar starts from SUNDAY as the first day.

T-SQL – How to get the Financial Quarter details of a date field

declare @table table ( [Paid Date] date ) insert into @table values('20150102'),('20150512'),('20150830'),('20151231'),('20141230') ;WITH Quarters AS ( SELECT Q = 'Q1', MonthBegin = 1, MonthEnd = 3 UNION SELECT Q = 'Q2', MonthBegin = 4, MonthEnd = 6 UNION SELECT Q = 'Q3', MonthBegin = 7, MonthEnd = 9 UNION SELECT Q = 'Q4', MonthBegin = 10, MonthEnd = 12 ) SELECT [paid date],[Quarter] =…

T-SQL to Display Weekends Between two Dates

Different ways to find the weekend between two given dates.

DECLARE @beginDate Date='20150101', @endDate Date='20150131' DECLARE @Calendar Table (CalendarDate Date Primary key, IsWeekend Bit) WHILE @beginDate <= @endDate BEGIN INSERT INTO @Calendar SELECT @beginDate As CalendarDate ,(Case When DATEPART(Weekday, @beginDate) In (7, 1) Then 1 Else 0 End) As IsWeekend Set @beginDate = DateAdd(Day, 1,…