/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

8 votes268 views1 answer
Insert a select statement into a table
SQL
3 votes428 views9 answers
Linq to sql converter online
SQL
0 vote289 views1 answer
To_date sql
SQL
0 vote287 views1 answer
Sql query to return field name of a table
SQL
10 votes304 views1 answer
Oracle view dependencies
SQL
0 vote303 views1 answer
Postgresql stored procedure update table values
SQL
1 vote270 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote280 views1 answer
MySQL - How to find word with the most similar beginning
SQL
1 vote275 views1 answer
Float precision in psql
SQL
1 vote256 views1 answer
Postgresql convert text to float
SQL