sql to print dates between two given dates

Question

1.00/5 (1 vote)

See more:

any 1 help me to write sql to print dates between two given dates. ie two dates are given for example (01-12-2006 and 05-12-2006) and want to print dates like 01-12-2006
02-12-2006
03-12-2006
04-12-2006
05-12-2006
thanks in advance

Posted 16-Feb-14 17:55pm

Pandiarajan A

Add a Solution

Comments

Pandiarajan A 17-Feb-14 1:18am

sorry i am not using SQL query. i have a simple program one text box have one date and another text box have another date values. my result shows in listbox how to get it? pls help me

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Dnyaneshwar**@Pune · Answer 1 · 2014-02-16T18:05:00

Solution 2

http://stackoverflow.com/questions/1378593/get-a-list-of-dates-between-two-dates-using-a-function[^]
http://forums.asp.net/t/1761386.aspx?How+to+create+a+flipcart+like+panel+for+showing+products+in+gridview[^]

Posted 16-Feb-14 18:05pm

Dnyaneshwar@Pune

Peter Leow · Answer 2 · 2014-02-16T19:06:00

Solution 5

Assuming you are using sql server:

SQL

SELECT * FROM table1
WHERE CONVERT(date, nameofdatefield, 105) BETWEEN '01-12-2006' and '05-12-2006'

Posted 16-Feb-14 19:06pm

Peter Leow

Updated 16-Feb-14 19:07pm

v2

TrushnaK · Answer 3 · 2014-02-16T18:04:00

try this use between operator:-

SQL

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

eg:-

SQL

SELECT dates
FROM orders
WHERE order_date BETWEEN TO_DATE ('2003/01/01', 'yyyy/mm/dd')
AND TO_DATE ('2003/12/31', 'yyyy/mm/dd');

refer:-
http://www.w3schools.com/sql/sql_between.asp[^]

prakashdotnet · Answer 4 · 2014-02-16T18:10:00

Solution 3

SQL

Declare @StartDate Date = '12/01/2006'
Declare @EndDate Date = '12/05/2006'
Declare @CurrDate Date
set @CurrDate = @StartDate

WHILE @CurrDate <= @EndDate
BEGIN

    PRINT @CurrDate
    SET @CurrDate = DATEADD(DD,1,@CurrDate)
END

Posted 16-Feb-14 18:10pm

prakashdotnet

Updated 16-Feb-14 18:42pm

v2

**Nirav Prabtani** · Answer 5 · 2014-02-16T18:10:00

May be this ids useful 4 u......manipulate this code according to your need

SQL

declare @fromDate Date,@toDate Date
set @fromDate='12-01-2006'
set @toDate='12-05-2006'

;WITH sample AS (
			SELECT CAST(@fromDate AS DATETIME) AS Dates
			UNION ALL
			SELECT DATEADD(dd, 1, Dates)
			FROM sample s
			WHERE DATEADD(dd, 1, Dates) <= CAST(@toDate AS DATETIME))
			select * from sample