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 vote291 views1 answer
Python escape mysql
SQL
0 vote293 views1 answer
Frename oracle
SQL
1 vote286 views1 answer
Multiple count in sql
SQL
0 vote289 views1 answer
Mysql 8 error on identified by
SQL
0 vote311 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote302 views3 answers
How to run sql query
SQL
16 votes365 views2 answers
Sql vs nosql
SQL
1 vote295 views1 answer
How to remove identity from a column in sql server
SQL
1 vote297 views1 answer
Find a column in all tables postgres
SQL
4 votes278 views1 answer
Mysql ip address
SQL