/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 vote224 views1 answer
Connect postgresql using a connection string
SQL
5 votes290 views2 answers
How to ascending order in sql
SQL
0 vote237 views1 answer
Mysql grant user wildcard database
SQL
0 vote238 views1 answer
Mysql read row
SQL
0 vote229 views1 answer
Get time component of datetime sql
SQL
0 vote235 views2 answers
Sql query in dax power bi
SQL
0 vote235 views1 answer
Import sql dump into postgresql database
SQL
1 vote232 views2 answers
Oracle replace
SQL
0 vote254 views1 answer
Express api ith mysql data
SQL
1 vote229 views1 answer
Sql get missing id
SQL