#datepart

[rianthas]

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

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.

View On WordPress

[prashantjayaram]

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

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] =…

View On WordPress

[prashantjayaram]

T-SQL to Display Weekends Between two Dates

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,…

View On WordPress