/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

2 votes138 views1 answer
Mysql application.properties spring boot
SQL
0 vote138 views1 answer
Yesql
SQL
0 vote125 views1 answer
Sql menampilkan data tabel
SQL
1 vote171 views1 answer
Postgresql blocked on mac
SQL
15 votes217 views3 answers
Postgresql change column type
SQL
0 vote144 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote153 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote149 views1 answer
Check if mysql db is used
SQL
2 votes146 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote138 views1 answer
SQL: calculate hours from two dates
SQL