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 vote264 views1 answer
Pl sql join 3 tables
SQL
0 vote187 views1 answer
Split a string with expression and get the last value of split sql
SQL
6 votes219 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
2 votes213 views1 answer
How to search table name in stored procedure in sql server
SQL
1 vote216 views1 answer
Sqlite3 read only
SQL
2 votes212 views1 answer
Get hour from date sql
SQL
1 vote232 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
4 votes224 views2 answers
Oracle sql group by date year
SQL
8 votes223 views2 answers
Mysql get first x characters
SQL
0 vote208 views1 answer
Oracle last character of string
SQL