How to find a between dates using sql?

Question

0.00/5 (No votes)

See more:

, +

Am working on a reservation room ticket booking website.i got a error,the error was i have a from date and to date when i select from date and to date and submit the reservation details into the data base..
the value will saved into this type..

From date : 25/08/2014
To date : 29/08/2014

Problem: when i book another reservation details i dont want the date between 25/08/2014 to 29/08/2014. the between dates are not saved in database.only the from date and to date are saving into the database.how to block between date using sql...

Posted 23-Aug-14 0:32am

RajeeshMenoth

Add a Solution

Comments

george4986 23-Aug-14 6:37am

post ur code here

1 solution

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)

vangapally Naveen Kumar · Answer 1 · 2014-08-23T01:13:00

1)First you can find all the dates between from and to dates in SQL Server like

Create PROCEDURE getAllDaysBetweenTwoDate
(
@FromDate DATETIME,    
@ToDate DATETIME
)
AS
BEGIN
    
    DECLARE @TOTALCount INT
    SET @FromDate = DATEADD(DAY,-1,@FromDate)
    Select  @TOTALCount= DATEDIFF(DD,@FromDate,@ToDate);

    WITH d AS 
            (
              SELECT top (@TOTALCount) AllDays = DATEADD(DAY, ROW_NUMBER() 
                OVER (ORDER BY object_id), REPLACE(@FromDate,'-',''))
              FROM sys.all_objects
            )
        SELECT AllDays From d
        
    RETURN 
END
GO

then compare selected date with the result set.

2)At Code Behind:
Get the all dates between from and to dates through loop then compare with selected date.