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 vote247 views1 answer
Oracle query to find schema you are working on
SQL
13 votes217 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote251 views1 answer
Less than date query sqlachemy
SQL
0 vote236 views1 answer
Sql server separar numeros por comas miles
SQL
1 vote225 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote227 views1 answer
Sql roll up rows into columns
SQL
1 vote241 views1 answer
List all triggers in SQL Server
SQL
10 votes289 views4 answers
Join multiple tables in sql
SQL
2 votes242 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote199 views1 answer
How to set field to null in sql
SQL