mysql time query
Posted: Wed Aug 03, 2005 6:22 am
Hi i am trying to select records whose time fall into a certain time period.
at the moment the query looks like this
this brings up a query error
i'm guessing that perhaps these values may need to be formatted?
I am using php as my language
any ideas???
thanks in advance
alex
at the moment the query looks like this
Code: Select all
select * from activities where learn_time between 01:00:00 and 03:00:00i'm guessing that perhaps these values may need to be formatted?
I am using php as my language
any ideas???
thanks in advance
alex