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

17 votes155 views2 answers
T_sql contains
SQL
5 votes143 views1 answer
Oracle ora-00054 causes
SQL
1 vote151 views1 answer
Pl sql insert into table
SQL
1 vote312 views2 answers
Sql unique rows
SQL
0 vote137 views1 answer
How to to get current date and time in sql
SQL
4 votes144 views1 answer
Mysql timestamp in laravel migration
SQL
4 votes144 views2 answers
Mysql select where starts with
SQL
1 vote145 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
0 vote148 views1 answer
Sum value by month sql
SQL
1 vote166 views3 answers
Connection string mysql
SQL