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 votes198 views2 answers
Join update query in sql
SQL
0 vote214 views1 answer
Mysql dump for selected row
SQL
0 vote219 views1 answer
Calculate age in sql
SQL
1 vote197 views1 answer
Postgres regex remove special characters
SQL
0 vote208 views2 answers
Tsql row number
SQL
0 vote211 views1 answer
Mysql persistence.xml
SQL
0 vote184 views1 answer
Lister les index d'une table oracle
SQL
0 vote186 views1 answer
Mysql earlier than date
SQL
0 vote208 views1 answer
How to fetch unique records from two tables
SQL
-1 vote195 views1 answer
How to open blade file from blade in laravel
SQL