/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

4 votes244 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
8 votes238 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote254 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote234 views1 answer
Add multiple field in table sql
SQL
1 vote239 views1 answer
Where to locate set password for mysql
SQL
0 vote234 views3 answers
Select random sql
SQL
2 votes225 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote230 views1 answer
Postgresql print variable
SQL
6 votes242 views1 answer
Oracle trigger after logon on database
SQL
1 vote239 views1 answer
Cross schema query oracle 2 users
SQL