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

0 vote185 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote167 views1 answer
Sub blocks in sql
SQL
28 votes181 views6 answers
Mysql change user password
SQL
0 vote169 views2 answers
How to update the multiple rows in sql
SQL
0 vote198 views1 answer
Dual in db2
SQL
8 votes170 views1 answer
How to remove tables from postgresql
SQL
0 vote203 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
1 vote171 views1 answer
Oracle datafile max size 32gb
SQL
31 votes174 views4 answers
Mysql grant execute
SQL
10 votes172 views3 answers
Join multiple tables sql
SQL