Datetime sql server week

Sql server week number

datepart(wk, DateToParse)

Source: grepper.com

Sql server get week dates from week number

SELECT  
	DATEADD(DAY, 2 - DATEPART(WEEKDAY, GETDATE()), CAST(GETDATE() AS DATE)) [Week_Start_Date],  
	DATEADD(DAY, 8 - DATEPART(WEEKDAY, GETDATE()), CAST(GETDATE() AS DATE)) [Week_End_Date]

-2

Source: c-sharpcorner.com

Similar codes

2 votes318 views1 answer
Oracle percentage
SQL
0 vote322 views1 answer
Get who is hired in february in sql
SQL
0 vote313 views1 answer
Synapse sql table set pk
SQL
0 vote338 views1 answer
Neo4j command to run script file
SQL
0 vote288 views1 answer
Declaring variables in pl sql
SQL
0 vote319 views1 answer
Sql tablo sp
SQL
0 vote319 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
16 votes352 views3 answers
T-SQL Add Column
SQL
4 votes335 views5 answers
Get last query in codeigniter 4
SQL
1 vote311 views1 answer
Select if then postgresql
SQL