help date and time query

knowmeifyou

Active member
Joined
Jun 16, 2013
Messages
26
Programming Experience
Beginner
please help me, the datatype of begin_time is TIME and date_needed is DATE

when i run this query

select transact_id, begin_time, end_time, transact_status, date_needed from tble_transact_reserve where transact_status = 'Reserved' and tble_transact_reserve.date_needed >= DATE(NOW()) group by transact_id

i got this as output

Untitled.png

but when i run this

select transact_id, begin_time, end_time, transact_status, date_needed from tble_transact_reserve where transact_status = 'Reserved' and tble_transact_reserve.date_needed >= DATE(NOW()) and tble_transact_reserve.begin_time >= CURRENT_TIME()group by transact_id

MySQL returned an empty result set but why? the current time is 12:29
 
Back
Top