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 vote219 views1 answer
How to define a save method in ruby for sql databases
SQL
1 vote227 views1 answer
Oracle check table space
SQL
0 vote223 views1 answer
How to find database collation in postgres
SQL
0 vote247 views1 answer
Wordpress database query change url
SQL
0 vote242 views1 answer
Start stop mysql linux
SQL
0 vote267 views1 answer
How to get table id sequence postgres
SQL
20 votes223 views4 answers
Sqlite create table if not exists
SQL
10 votes221 views4 answers
Mysql one week ago
SQL
0 vote278 views1 answer
How to rename a database in tsql
SQL
0 vote233 views1 answer
Psql get table data types
SQL