/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

1 vote159 views2 answers
Mysql update table from another table
SQL
1 vote159 views2 answers
Oracle create synonym
SQL
0 vote120 views1 answer
Query for maximum salary
SQL
0 vote153 views1 answer
Normalization in database 2nd normal form
SQL
0 vote170 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
9 votes142 views3 answers
Show table columns mysql command line
SQL
0 vote176 views1 answer
Primary key start from number
SQL
0 vote158 views1 answer
Sqlite3 update select
SQL
0 vote172 views2 answers
Insert data mysql with cmd
SQL
13 votes159 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL