SQL Query to print Week days.

Revati S Misra 525 20 Dec 2024

Write an SQL Query to print all the days of the week.

1 Answers

Ashutosh Patel 20 Dec 2024

To print all the days of the week, you can use the recursive CTE. Here is the basic SQL Query to find all the week-days from Monday to Saturday,

USE your_database
GO
WITH CTE_WeekDay(Number, WeekDays) AS 
(
SELECT 0, DATENAME(DW, 0)
UNION ALL
SELECT Number+1, DATENAME(DW, Number+1) FROM CTE_WeekDay WHERE Number < 6
)
SELECT WeekDays FROM CTE_WeekDay

Output:

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

SQL Query to print Week days.

Can you answer this question?

1 Answers