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

44 votes393 views4 answers
Mysql alter table add column first
SQL
0 vote309 views1 answer
Mysql join column order By and group By
SQL
0 vote282 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote304 views1 answer
Hoq to import database source
SQL
13 votes307 views2 answers
Get tables in database sql
SQL
0 vote291 views1 answer
Mysql change timestamp on update
SQL
7 votes299 views3 answers
Select latest entry in sql table
SQL
0 vote292 views2 answers
Oracle create chain rule
SQL
0 vote340 views1 answer
Python mysql check if database exists
SQL
0 vote292 views1 answer
Sql delete where x or y or z
SQL