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 vote105 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote110 views1 answer
Count number of entires by months sql
SQL
11 votes124 views1 answer
Oracle insert from select
SQL
0 vote118 views1 answer
Every Derived yable must have its own alias
SQL
8 votes107 views2 answers
Phpmyadmin password
SQL
27 votes105 views5 answers
Add column in table
SQL
0 vote115 views1 answer
Mysql shell ERROR: Not connected.
SQL
-2 votes117 views1 answer
Create trigger syntax
SQL
0 vote159 views1 answer
Creating sqeuence in oracle database
SQL
0 vote114 views1 answer
How to check replication lag in mySQL
SQL