SQL Date Range search between rows

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

I have a table with the following structure

Period Name | Start Date | End Date
------------------------------------------
JAN | 01/01/2013 |31/01/2013
FEB | 01/02/2013 |28/02/2013
MAR | 01/03/2013 |31/03/2013

I want to search using a start date and end date. Ex: I want to know the periods between Jan 15 to Feb 15and I should get Jan and Feb. I tried the below using the below query but it is showing me all the records

Select * FROM FinancialPeriods WHERE (StartDate>='15/01/2014') Or (EndDate<='15/02/2014')

Appreciate your quick help

Thanks in advance

Sanaj

Posted 6-May-14 10:52am

Sanaj Muhammed Shaji

Add a Solution

Comments

j snooze 6-May-14 18:03pm

Try this(Sorry I did it in US datetime format instead of adding all the datetime converting.)

declare @startdate datetime,
@enddate datetime

select @startdate = '1/15/2013', @enddate = '2/15/2013'

Select * FROM FinancialPeriods
WHERE (@startdate between startDate and enddate)
or (@enddate between startDate and enddate)

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)

Peter Leow · Answer 1 · 2014-05-06T14:53:00

Solution 1

OR will returns records as long as they meet one of the conditions in the WHERE clause, try 'AND':
Select * FROM FinancialPeriods WHERE (StartDate>='15/01/2014') AND (EndDate<='15/02/2014')

Posted 6-May-14 14:53pm

Peter Leow