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 vote335 views1 answer
Mysql collation
SQL
20 votes360 views5 answers
Sql show tables
SQL
0 vote358 views1 answer
Sql server concat null
SQL
0 vote351 views1 answer
How to find columns with null values in sql
SQL
0 vote361 views1 answer
Mysql start of today
SQL
0 vote382 views1 answer
Connecting mySQL to STS
SQL
0 vote345 views1 answer
Show create table in postgresql
SQL
0 vote375 views1 answer
Psotgres multiple values
SQL
5 votes396 views1 answer
Oracle source query
SQL
0 vote371 views1 answer
MySQL INSERT IGNORE Statement
SQL