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 vote189 views1 answer
Mysql Like(searching in the string)
SQL
0 vote169 views1 answer
Oracle sql date summer time
SQL
1 vote182 views1 answer
Timestamp in sqlite
SQL
5 votes177 views1 answer
Mysql last day of next month
SQL
1 vote202 views1 answer
Mariadb get column names from table
SQL
11 votes177 views2 answers
Oracle all source
SQL
0 vote186 views2 answers
Tsql row number
SQL
1 vote182 views1 answer
Where database run
SQL
2 votes174 views2 answers
Sql query to copy data from one column to another
SQL
0 vote221 views1 answer
Pgadmin check database
SQL