/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

10 votes123 views2 answers
Django mysql
SQL
0 vote187 views1 answer
Oracle allow space to user
SQL
3 votes161 views2 answers
Mysql create database
SQL
0 vote212 views1 answer
Postgres truncate with cascade
SQL
0 vote188 views1 answer
Grant owner postgresql
SQL
0 vote168 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote165 views1 answer
Go install mysql
SQL
0 vote172 views1 answer
Not equal to blank in mysql
SQL
19 votes176 views6 answers
What is mySQL
SQL
1 vote158 views1 answer
Foreign key constraint in ms sql
SQL