/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

17 votes116 views3 answers
Cast in sql server
SQL
1 vote120 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote111 views1 answer
Postgres call view
SQL
0 vote142 views1 answer
Mysql preg replace
SQL
0 vote135 views1 answer
Oracle current date minus 1 day
SQL
34 votes113 views6 answers
Sql change data type
SQL
24 votes118 views6 answers
Sql change table name
SQL
0 vote121 views1 answer
Implicit inner join table alias
SQL
0 vote115 views1 answer
Mysql workbench view
SQL
8 votes142 views1 answer
Mysql dump restore
SQL