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

3 votes291 views2 answers
Update Query in SQL Server
SQL
50 votes345 views6 answers
Sql duplicate rows
SQL
10 votes273 views1 answer
Oracle all_dependencies
SQL
4 votes226 views3 answers
Create table if not exists postgresql
SQL
0 vote470 views1 answer
Get first match in each group mysql query
SQL
8 votes268 views1 answer
Database backup in mysql server recovery
SQL
0 vote290 views1 answer
Excel vba import data to sql server
SQL
1 vote272 views1 answer
Oracle sql create view
SQL
11 votes295 views2 answers
How to import mysql database command line
SQL
0 vote278 views2 answers
Disadvantages of stored procedures sql
SQL