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 vote269 views1 answer
How to test for sql injection
SQL
0 vote275 views1 answer
Create table as select sql server error
SQL
1 vote254 views2 answers
Replace text in sql
SQL
0 vote268 views1 answer
Test database for sql
SQL
1 vote275 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
4 votes300 views1 answer
How to drop a database in sql server when it is in use
SQL
10 votes267 views3 answers
Sql select between two dates
SQL
4 votes254 views1 answer
Sql group by year
SQL
0 vote262 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote278 views1 answer
How to remove quotes from a string in ssis load file
SQL