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

24 votes111 views6 answers
Sql change table name
SQL
0 vote123 views1 answer
Mysql enter ubuntu
SQL
0 vote102 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
3 votes174 views1 answer
Mysql group_concat distinct
SQL
1 vote128 views3 answers
Alter schema sql server
SQL
0 vote133 views1 answer
How to check foreign key constraint in sql
SQL
5 votes114 views2 answers
Create function postgresql
SQL
1 vote104 views1 answer
Mysql select row with max value group by
SQL
0 vote106 views2 answers
Pop sql insert value into
SQL
0 vote105 views1 answer
How to check if there is no database schema
SQL