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 vote173 views1 answer
What is between keyword used for
SQL
2 votes173 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote186 views1 answer
Sql server isnull function nor working count
SQL
0 vote200 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote172 views1 answer
Sql select by content lenght
SQL
1 vote167 views1 answer
Mysql show table character set
SQL
0 vote192 views1 answer
Oracle last connexion
SQL
1 vote185 views1 answer
Create table variable in sql stored procedure
SQL
34 votes218 views6 answers
Install mysql client ubuntu
SQL
7 votes179 views4 answers
Index in mysql
SQL