/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 vote355 views1 answer
How to get number of months between 2 dates sql server
SQL
6 votes297 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
0 vote310 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
-1 vote294 views1 answer
Mysql change database charset and collation
SQL
0 vote284 views1 answer
Sql server split string and insert into table select
SQL
0 vote307 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
11 votes287 views4 answers
Query DISTINCT
SQL
1 vote306 views2 answers
Mysql trim spaces
SQL
4 votes294 views1 answer
Oracle session date format
SQL
0 vote280 views1 answer
Add sqlite3 in lumen
SQL