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 vote316 views1 answer
Mysql find tables with column name
SQL
1 vote372 views1 answer
T-sql find object by name
SQL
0 vote379 views1 answer
Add new column in sql with foreign key
SQL
0 vote408 views2 answers
Mysql insert rows to another database
SQL
2 votes329 views1 answer
Import large .sql files into lampp
SQL
0 vote350 views1 answer
Incorrect string value: mysql
SQL
2 votes315 views1 answer
Install sqlite npm
SQL
0 vote363 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote336 views1 answer
Mssql check if date is greater than today
SQL
0 vote316 views1 answer
Oracle archivemode
SQL