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 vote239 views1 answer
Print mysql
SQL
0 vote229 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote228 views1 answer
Example of sql querry result sepapreted by comma
SQL
2 votes185 views1 answer
Oracle sql drop column if exists
SQL
0 vote195 views1 answer
Select all domains of database firbird
SQL
0 vote205 views1 answer
Mql5 list all available symbols
SQL
0 vote246 views1 answer
Python list from sql
SQL
6 votes214 views2 answers
WHERE value IS sql
SQL
19 votes226 views4 answers
Rename database in sql
SQL
0 vote186 views1 answer
Postgresql add leading zeros
SQL