/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 vote111 views1 answer
Mysql check if lowercase
SQL
0 vote110 views1 answer
How to get specific salary in sql
SQL
39 votes169 views4 answers
Select duplicates in sql
SQL
1 vote81 views1 answer
Sql convert month name to number
SQL
0 vote113 views1 answer
Sql get highest date from 3 tabels
SQL
44 votes180 views6 answers
Rename command in sql
SQL
4 votes111 views2 answers
REST API
SQL
1 vote95 views1 answer
Oracle show execution plan
SQL
0 vote102 views1 answer
How to install postgresql on wsl
SQL
0 vote102 views1 answer
Oracle job schedules
SQL