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

1 vote338 views2 answers
Postgres select from last 3 months
SQL
0 vote204 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote255 views1 answer
Oracle running queries
SQL
0 vote202 views1 answer
Python mysql show databases
SQL
2 votes288 views1 answer
Mariadb json select
SQL
0 vote208 views1 answer
Every Derived yable must have its own alias
SQL
0 vote153 views1 answer
Oracle sql developer script output limit
SQL
9 votes259 views6 answers
Replace sql
SQL
0 vote235 views1 answer
Sql server insert inner join
SQL
0 vote193 views1 answer
Sql composite key
SQL