/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

25 votes178 views5 answers
Date in mysql
SQL
0 vote161 views1 answer
Recursive query herarchical data sql server
SQL
0 vote252 views2 answers
Mysql insert rows to another database
SQL
1 vote173 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
1 vote168 views1 answer
Crontab every month
SQL
0 vote182 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
17 votes189 views3 answers
Postgresql list users
SQL
0 vote184 views1 answer
To_date sql
SQL
0 vote165 views1 answer
Oracle db get table sizes
SQL
0 vote227 views1 answer
What is metadata in sql
SQL