Start and end times of appointments should be stored in UTC in DB

A user who is creating an implementation with another plugin ran into problems with the $appointment->get_start() and $appointment->get_end() dates.

After checking the DB, I realized those dates are stored as ‘20200410030000' and they are returned with the mentioned functions like this: ‘1586487600’. In my case, the WP is configured on Paris time (UTC+2) and when doing comparisons with the time() function I need to take the difference into account.

It would be much better if the values stored in the DB would be UTC so that it would be easier to use them in cases like these.

Reported here.

Comments (1)