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 vote161 views1 answer
Oracle lock user
SQL
0 vote193 views1 answer
Mysql range of dates overlap
SQL
0 vote204 views1 answer
Postgres regex word boundary
SQL
2 votes199 views1 answer
Oracle sql merge
SQL
1 vote174 views1 answer
Woocommerce mysql price table
SQL
1 vote178 views2 answers
Grab part of a string sql
SQL
2 votes175 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote189 views3 answers
Epoch to datetime
SQL
17 votes176 views4 answers
Sort by mysql
SQL
0 vote280 views1 answer
SQL query to verify the size of the table
SQL