/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

0 vote352 views1 answer
Tsql default value when no value returned by query
SQL
0 vote399 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote311 views1 answer
'0000-00-00' for column '
SQL
0 vote342 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote384 views1 answer
Second Step in installing SQL workbench
SQL
0 vote376 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote346 views1 answer
1 column values in to 1 single row in sql
SQL
3 votes369 views2 answers
Sql server current date without time
SQL
0 vote352 views1 answer
How should I pass a table name into a stored proc?
SQL
-1 vote372 views2 answers
First letter capital in mysql query
SQL