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 vote349 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote342 views1 answer
Tsql generate rows
SQL
2 votes364 views1 answer
How to delete columns in sql
SQL
32 votes434 views6 answers
Rename column mysql
SQL
2 votes354 views2 answers
How to rename column name in sql server using query
SQL
2 votes388 views2 answers
Postgresql get table names
SQL
0 vote430 views1 answer
How to check common records in 2 table
SQL
0 vote396 views1 answer
Create user faunadb
SQL
3 votes355 views1 answer
Sql replace character in string in all records
SQL
3 votes295 views2 answers
Mysql sum with condition
SQL