[perleo]

In my table I have a column called time, and the entries in as YYYY-MM-DD

I want to query to return the records between two times as in 01:00:00 and 03:00:00

I have a dropdown list in my html form with time entries like so:

01
02
03
04
...
20
21
22
23

My SQL query just returns all rows

select * from table WHERE TIME(time) BETWEEN '01' AND '03'

Whats the correct way to do this.. ?

[darkfreak]

Originally Posted by perleo

In my table I have a column called time, and the entries in as YYYY-MM-DD

I want to query to return the records between two times as in 01:00:00 and 03:00:00

If you have saved only the date (year, month, day) I guess it's impossible to get reasonable results using time (hour, minute, second). See the MySQL manual for time/date columns.

[xtremenw]

Originally Posted by perleo

In my table I have a column called time, and the entries in as YYYY-MM-DD

I want to query to return the records between two times as in 01:00:00 and 03:00:00

I have a dropdown list in my html form with time entries like so:

01
02
03
04
...
20
21
22
23

My SQL query just returns all rows

select * from table WHERE TIME(time) BETWEEN '01' AND '03'

Whats the correct way to do this.. ?

try:

Code:

SELECT * FROM TABLE WHERE HOUR(time) BETWEEN 1 AND 3;