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

3 votes312 views1 answer
Sql datetime as date
SQL
0 vote201 views1 answer
Join in update query in mysql
SQL
0 vote201 views1 answer
New rails app with mysql
SQL
7 votes184 views6 answers
Group_concat mysql
SQL
0 vote217 views1 answer
Reindex mssql table
SQL
0 vote194 views1 answer
Postgres drop type
SQL
0 vote209 views1 answer
Get schema of table sql
SQL
0 vote216 views2 answers
Starts and end with vowel sql
SQL
0 vote190 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
1 vote182 views1 answer
Sql delete row with auto increment
SQL