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 vote142 views1 answer
Power bi union columns
SQL
0 vote283 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
3 votes163 views1 answer
Force using index oracle
SQL
1 vote141 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote144 views1 answer
Hibernate with springboot mysql
SQL
2 votes148 views1 answer
How to get weekday from old date in sql
SQL
0 vote137 views1 answer
How many rows affected in sqllite
SQL
0 vote140 views1 answer
Sql server select record with max id
SQL
1 vote140 views1 answer
Sqlite check if row exists
SQL
0 vote125 views3 answers
Sql count condition
SQL