Get week day from date in sql

How to get weekday from old date in sql

select format(columnName, 'dddd') as WeekDay from tableName; -- SQL Server 17

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;

Extract weekday from date in sql

SELECT WEEKDAY(date);

-1

Similar codes

0 vote242 views1 answer
List MySQL Table and Index Size
SQL
1 vote268 views1 answer
Vagrant mysql downgrade version
SQL
1 vote245 views1 answer
Oracle db create new schema
SQL
0 vote250 views1 answer
Oracle gather table statistics
SQL
2 votes263 views2 answers
Run mysql command from bash
SQL
0 vote279 views1 answer
Sql: extract day text from datetime value
SQL
2 votes255 views1 answer
Get first 2 letter in sql
SQL
0 vote259 views1 answer
Create query in where clasue
SQL
2 votes245 views1 answer
Update trigger
SQL
0 vote246 views1 answer
Mysql jdbc timezone
SQL