mysql event scheduler execute_at wrong time

[Mark Riedel]

hallo,
i am trying to create an event using php.

Quote

CREATE EVENT `myevent`ON SCHEDULE AT '$date $time' ON COMPLETION NOT PRESERVE ENABLE DO TRUNCATE rmark.log;

The event is being saved in mysql.events BUT it would not be executed, because execute_at why ever is being set two hours before the set time. The variables $date and $time are right from the logs you can see the right time gets into the database:

Quote

57 Query CREATE EVENT `myevent`ON SCHEDULE AT 2012-06-23 00:09:04' ON COMPLETION NOT PRESERVE ENABLE DO TRUNCATE rmark.log

But in execute_at is 2012-06-22 22:09:04



Edited 1 time(s). Last edit at 06/22/2012 04:37PM by Mark Riedel.