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

3 votes185 views1 answer
Postgres count distinct
SQL
0 vote228 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote196 views1 answer
Insert or update sql firebird
SQL
2 votes309 views1 answer
Tsql copy table
SQL
25 votes211 views4 answers
Metadata
SQL
0 vote126 views1 answer
FindAllBy
SQL
2 votes184 views1 answer
Wait delay in sql server
SQL
60 votes554 views6 answers
Add column in sql
SQL
0 vote199 views1 answer
Grant owner postgresql
SQL
0 vote179 views1 answer
Call rest api from postgresql
SQL