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 votes347 views3 answers
Stop mysql service ubuntu
SQL
0 vote368 views1 answer
Sql find leading space
SQL
1 vote368 views1 answer
Get table column names sql ssms
SQL
2 votes367 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote351 views2 answers
Null value in column violates not-null constraint
SQL
0 vote349 views1 answer
Procedures sql insert mysql
SQL
4 votes367 views4 answers
Oracle tablespace tables list
SQL
9 votes401 views4 answers
Postgresql export database
SQL
0 vote398 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote363 views1 answer
Oracle job class
SQL