date range query in sql

Question

0.00/5 (No votes)

See more:

hi all,

i have a table which contains startdate and enddate column.

ex startdate enddate
2011-07-13 00:00:00.000 2011-07-14 00:00:00.000

i want to perform a search on the basis of startdate
the issue is that if i enter strat date as 2011-07-13 00:00:01.000

the above record should be displayed.

Posted 20-Jul-11 7:29am

suniltikli

Add a Solution

8 solutions

Solution 1

Try something from here[^] - it may help.

Posted 20-Jul-11 7:51am

Abhinav S

Solution 3

Not that difficult

SELECT *
FROM table
WHERE @date >= startdate AND @date <= enddate

Posted 20-Jul-11 7:54am

Not Active

Solution 4

Or, convert the datetime into a date:

SQL

SELECT * FROM yourTable WHERE (CONVERT([date], @date) = CONVERT([date], startdate))

Posted 20-Jul-11 8:16am

JOAT-MON

Solution 5

select

SQL

* from Attendance_Master where datename(d,LoginTime)=datename(d,@date)
                             and datename(m,LoginTime)=datename(m,@date)and  datename(year,LoginTime)=datename(year,@date)

Posted 21-Jul-11 1:28am

Mohd Wasif

Solution 6

Hi ,

it picks all the records based on the condition

select * from table where date between startdate and enddate.

Posted 21-Jul-11 1:36am

shefeekcm

Comments

shefeekcm 21-Jul-11 7:39am

ust try this man.

Solution 7

Write the following code to get your work done ..... make sure that you enter the date in single quotation then only it will work properly .... or else it will not work as you expect it to work .... but at the same time it will not throw you any error also .....

so please make sure that you use the quotation while entering the date

SQL

SELECT *
FROM table
WHERE @date >= startdate AND @date <= enddate

Posted 21-Jul-11 5:31am

Pravin Kumar Dubey

Solution 8

select * from table where date in ('start date','end date')

Posted 21-Jul-11 6:00am

DAVID PRASANTH KUMAR

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)

wizardzz · Accepted Answer · 2011-07-20T07:52:00

Solution 2

@givenTime = '2011-07-13 00:00:01.000'

select * from [table] where startdate < @givenTime and enddate > @givenTime

Posted 20-Jul-11 7:52am

wizardzz

v2