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

2 votes293 views2 answers
Mysql all columns
SQL
0 vote334 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
14 votes317 views3 answers
Oracle sql limit results
SQL
1 vote391 views1 answer
Postgresql can you have null foreign key
SQL
-1 vote318 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote342 views2 answers
Compound operator in sql
SQL
0 vote316 views1 answer
User defined variables in sql
SQL
0 vote315 views1 answer
Mysql cast null to string
SQL
5 votes342 views1 answer
Add column table sql default value
SQL
0 vote315 views1 answer
Php get closest location by latitude longitude
SQL