/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 vote362 views1 answer
Mysql get date diff in months
SQL
0 vote329 views1 answer
Select only one row sql
SQL
1 vote331 views1 answer
T-SQL Alter the column data type
SQL
-1 vote320 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote353 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
1 vote374 views1 answer
Liquibase alter column type / length
SQL
2 votes373 views1 answer
Sql server check for value in multiple columns
SQL
0 vote344 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
3 votes342 views1 answer
RENAME table pl sql
SQL
0 vote334 views1 answer
Events not working db
SQL