/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

3 votes313 views2 answers
Brew start mysql
SQL
0 vote255 views1 answer
Oracle sql replace string in clob
SQL
0 vote303 views1 answer
Update table sql multiple set
SQL
0 vote330 views1 answer
Search In the Database using Text
SQL
3 votes297 views2 answers
Oracle for loop
SQL
1 vote298 views1 answer
Mysql show current queries
SQL
8 votes315 views1 answer
Oracle tablespace datafile max size
SQL
1 vote306 views1 answer
What is intersect
SQL
0 vote300 views1 answer
Is numeric in sql
SQL
2 votes307 views1 answer
Postgresql transaction
SQL