/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 vote247 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote253 views2 answers
Auto increment column in mysql query results
SQL
0 vote281 views2 answers
Compound operator in sql
SQL
0 vote242 views1 answer
Mysql select where text contains
SQL
2 votes260 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote255 views1 answer
C# mysql update statement set value to null
SQL
0 vote250 views1 answer
Convert int to varchar sql
SQL
0 vote270 views2 answers
Advantages of stored procedures sql
SQL
0 vote291 views1 answer
Sql script to remove default from column
SQL
1 vote259 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL