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
i got this as output

but when i run this
MySQL returned an empty result set but why? the current time is 12:29
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

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