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
Restart sql server command line linux
SQL
2 votes162 views1 answer
Postgresql format date dd/mm/yyyy
SQL
8 votes153 views1 answer
Oracle create datafile
SQL
0 vote145 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
0 vote158 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
11 votes288 views2 answers
Import mysql dump command line windows
SQL
0 vote151 views1 answer
Sql offfset
SQL
3 votes215 views1 answer
How to get yesterday date in sql
SQL
16 votes176 views3 answers
Get count of duplicate records
SQL
13 votes180 views3 answers
List all the tables in sql
SQL