forum

Home / DeveloperSection / Forums / SQL Query to print Week days.

Ask Question

SQL Query to print Week days.

Revati S Misra 63 20-Dec-2024

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

mssql server sql server sql

Updated on 20-Dec-2024

Revati S Misra

Skilled in SEO, content writing, and digital marketing. Completed several years of working in many organizations including multinational companies. I love to learn new things in life that keep me motivated.

Can you answer this question?

Answer

1 Answers

Ashutosh Kumar Verma

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:

forum

SQL Query to print Week days.

Revati S Misra

1 Answers

Liked By