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 vote98 views1 answer
Resulting Query
SQL
1 vote122 views2 answers
How to combine 2 tables in MySQL
SQL
2 votes114 views2 answers
Mysql show table column comments sql
SQL
0 vote118 views1 answer
Sql server rtrim everything after character
SQL
3 votes103 views2 answers
Funktion LOWER/UPPER sql
SQL
1 vote102 views1 answer
Update and replace mysql
SQL
4 votes103 views1 answer
Sql query to make a existing column auto increment
SQL
1 vote105 views2 answers
Pl sql case
SQL
1 vote105 views1 answer
Update foreign key value in mysql
SQL
5 votes96 views1 answer
Mysql get last day of month
SQL