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 vote192 views1 answer
Primary key start from number
SQL
0 vote173 views1 answer
Sql common columns
SQL
0 vote178 views1 answer
Sql server size of every table in a db
SQL
0 vote174 views1 answer
Initcap in mysql
SQL
0 vote195 views2 answers
Mysql select date from datetime
SQL
0 vote130 views2 answers
Avg() sql
SQL
0 vote194 views1 answer
Show tables in cassandra cql
SQL
2 votes168 views2 answers
Postgres trigger insert into another table
SQL
-1 vote154 views1 answer
Extract Data from SQL Server into XML Format
SQL
11 votes158 views1 answer
Oracle insert into where
SQL