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 vote114 views1 answer
Mysql select where text contains
SQL
0 vote139 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote122 views1 answer
Mysql where in keep order
SQL
3 votes190 views1 answer
Mysql group_concat distinct
SQL
0 vote124 views1 answer
Sql change date format
SQL
3 votes162 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
8 votes125 views1 answer
Oracle create datafile
SQL
0 vote136 views1 answer
View to table sql
SQL
0 vote122 views1 answer
Fix sqlite3 ruby on rails
SQL
1 vote125 views1 answer
Mariadb case switch
SQL