Sql date query

Anon

Hi!
I am trying to select all records from a table where a specified date falls within the range of 2 date fields (startdate and enddate).
I have tried this:

SELECT * from table WHERE startdate >= 2001-06-12 or enddate <= 2001-06-12;

This just selects all the records.

I have tried a few other variations but it never seems to work .
Can someone please help?!

craigh

SELECT * from table WHERE date BETWEEN 2001/06/12 AND 2001/06/15

I think that will get what you want.

Anon

That query selects records from a table where the date field falls between 2001/06/12 and 2001/06/15.

What I am trying to do is to select records from a table where a given/specific date is within the range of 2 different date field values.

something like:
Select * from table where 'value' BETWEEN datefield1 and datefield2

(This doesn't work though)
Do you know another way around this?
Please help!

ccgorman

Just out of curiosity try to put single quotes around the date and see if it works

SELECT * from table WHERE startdate >= '2001-06-12' or enddate <= '2001-06-12';

and perhaps try

SELECT * from table WHERE startdate >= '2001-06-12 00:00:00' or enddate <= '2001-06-12 23:59:59';

Anon

I would think an AND would work much better since every date/time in the world passes the OR condition.