Dates In MySql

Anon

any one can help me to query the data between two dates
(ie on column date (datefield)
I am using this query it does not work

select * from table where date between To_days('01/01/2002') and To_days('02/21/2002')

Thanks
Ramarao

andrin

I am not sure about this but I think you making it more complicated then I think it is. Given that you have your date in the format date I think you could write:

SELECT * FROM table WHERE date > '2002-01-01') AND date < '2002-01-31';

Maybe you have to write:

SELECT * FROM table WHERE (date > '2002-01-01') AND date < '2002-01-31');

This would give you all rows between 1 January and 31 January I think. If not I also would like to know :-)

/Andrin

buck2bcr

This may be a little late for you but this is what I have used and it seems to work:

$query_hours = "SELECT hours,ot FROM hours WHERE badge=\"$badge\" AND day >= \"$start\" AND day <= \"$finish\" ";

where $start is the beginning date and $finish is the ending date.

Buck