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

4 votes165 views1 answer
Check database name postgresql
SQL
3 votes189 views2 answers
Order by postgresql
SQL
3 votes176 views1 answer
Oracle user privileges
SQL
0 vote167 views1 answer
Sqlite referential integrity
SQL
1 vote124 views1 answer
Ms sql how to see active job current run time
SQL
1 vote168 views1 answer
Import sql file mysql commadn line
SQL
0 vote203 views1 answer
Doctors appointment
SQL
0 vote182 views1 answer
Array aggre distinct postgres
SQL
2 votes170 views1 answer
Mysql sysdate - 1 day
SQL
0 vote165 views1 answer
Select insert new table sql server
SQL