Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Display a date range between 2019 to 2023

Home
Forums
SQL

Display a date range between 2019 to 2023

sankeerth m

4yAsked Jul 20, 2022, 2:39 AM779SQL

Hi friends,

I want to display a date range between 2019 to 2023 can any one help me plz.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Amit Mohanty4y ago
Hey, check the below query.
DECLARE @MinDate DATE = '2019-01-01'
DECLARE @MaxDate DATE = '2023-12-01'

SELECT TOP (DATEDIFF(DAY, @MinDate, @MaxDate) + 1)
       Date = DATEADD(DAY, ROW_NUMBER() OVER(ORDER BY a.object_id) - 1, @MinDate)
  FROM sys.all_objects a CROSS JOIN sys.all_objects b
+1