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 vote149 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote259 views1 answer
Sqlite display data in separated columns
SQL
1 vote127 views1 answer
Mysql random limit 1
SQL
0 vote123 views1 answer
Sql database connectivity
SQL
0 vote117 views1 answer
Mysql multiple count
SQL
1 vote127 views1 answer
Mysql get latest duplicate rows
SQL
7 votes127 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
3 votes131 views1 answer
Mysql set field unique
SQL
0 vote122 views1 answer
C# mysql data reader from two tables
SQL
27 votes160 views5 answers
Mysql set password for user
SQL