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 vote245 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
1 vote221 views1 answer
Oracle user last connection date
SQL
8 votes314 views2 answers
Oracle auto increment primary key
SQL
0 vote196 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote187 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote326 views1 answer
Android sqlite add column if not exists
SQL
0 vote195 views1 answer
Mariadb cast null to 0
SQL
15 votes188 views4 answers
How to get all tables in sql
SQL
1 vote183 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote182 views1 answer
Join creating duplicate columns sqllite
SQL