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

1 vote277 views1 answer
Mysql stop password policy
SQL
0 vote276 views1 answer
Mysql preg replace
SQL
0 vote305 views1 answer
Nvl2 syntax
SQL
0 vote299 views1 answer
Prodection ready postgres database step by step
SQL
0 vote261 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote262 views1 answer
Oracle search in date columns
SQL
1 vote297 views1 answer
Spark sql convert string to date
SQL
0 vote280 views1 answer
Power bi union columns
SQL
3 votes267 views1 answer
Mysql load sql from file
SQL
11 votes285 views1 answer
Oracle view ddl
SQL