i have set the event yesterday i.e. on 2018-04-09 01:52:59 to update the status automatically.
so my question is when it will going to update the status?
Is status will update on 2018-04-10 01:52:59?
CREATE EVENT ProposalAbort ON SCHEDULE EVERY 1 day DO
update barter_proposals
set proposal_status="Aborted"
WHERE sent_date=DATE(CURDATE()-INTERVAL 1 DAY)
AND proposal_status = "Sent/Received"
i have set the event yesterday at this time(2018-04-09 01:52:59 ) which automatically update the status to "Aborted".i set the 1 day interval as shown in event query.
so i wanted to know whent it will change status to "Aborted" from "Sent/Received".is it today at 01:52:59?