/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

5 votes139 views2 answers
Create table
SQL
0 vote163 views1 answer
T sql check active deadlock
SQL
27 votes191 views5 answers
Mysql set password for user
SQL
0 vote171 views1 answer
How to insert same table data using mysql query
SQL
11 votes173 views3 answers
Sql line numbers
SQL
1 vote173 views1 answer
Get parameter value in mysql trigger
SQL
0 vote158 views1 answer
Heidisql check how much space a row
SQL
0 vote152 views1 answer
Object Information
SQL
0 vote148 views1 answer
Create boolean column in MySQL with false as default value?
SQL
0 vote190 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL