/SQL/Sql server get week dates from week number

Sql server get week dates from week number

Sql server week number

datepart(wk, DateToParse)

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]

Source: c-sharpcorner.com

Get week day from date in sql

SELECT TO_CHAR(your_table.date_colunm, 'DAY')
FROM your_table;

Similar codes

0 vote269 views1 answer
Groupby error in mysql
SQL
45 votes342 views5 answers
Grant all privileges mysql
SQL
0 vote309 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
2 votes291 views2 answers
How to run postgresql in linux
SQL
1 vote279 views1 answer
Tsql find foreign key references
SQL
0 vote308 views1 answer
How to fetch data from database in sql
SQL
0 vote298 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote273 views3 answers
Osx stop mysql service
SQL
4 votes261 views3 answers
Count with where
SQL
0 vote276 views1 answer
What alter does in db
SQL