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

1 vote96 views1 answer
Mysql show data from table
SQL
3 votes92 views2 answers
Sql end of month
SQL
4 votes110 views5 answers
Primary key
SQL
4 votes100 views2 answers
Tsql utf to local time
SQL
0 vote111 views1 answer
Mysql drop vs delete
SQL
3 votes57 views1 answer
System.debug apex
SQL
0 vote94 views4 answers
Forenkey code alchemy sql
SQL
4 votes100 views2 answers
Insert current date in mysql
SQL
-1 vote115 views1 answer
How to Activate the database
SQL
0 vote103 views1 answer
Asp.net core sql server stored procedure
SQL