我正在尝试编写一个查询,以检测预订在最后15分钟内的时间(这样它就知道预订即将完成(。所以到目前为止,我有:
UPDATE bookings b JOIN reservation_time_data r ON r.id = b.reservation_time SET b.reservation_processed = 'ending' WHERE reservation_date LIKE ? AND CURRENT_TIME BETWEEN(r.end_time AND r.end_time - '00:15:00.000000')
通常为了增加时间,我会使用ADDTIME()
,但对此我不确定。
您可以将其表述为:
where
reservation_date like ?
and r.end_time between current_time - interval 15 minute and current_time