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

4 votes129 views2 answers
Tsql utf to local time
SQL
0 vote132 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote155 views1 answer
Convert rows into columns in oracle
SQL
0 vote137 views4 answers
User defined function sql
SQL
1 vote142 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
1 vote161 views3 answers
Postgresql crete view
SQL
1 vote213 views1 answer
Create new table from old table with data
SQL
0 vote125 views1 answer
Drop all tables in azure sql database
SQL
1 vote145 views1 answer
Sql padd let with zeros
SQL
21 votes140 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL