How to select data from MySQL by date given offset?

Question

MySQL

There is a task of sending mailings by time but taking into account the time zone.
That is, the admin creates a task, enters the date, time and time zone for sending the newsletter (for example, January 29, 2018 at 21:15 in the Europe / Moscow time zone and another task is already in Asia / Ekaterinburg)
How to store it correctly and how to choose the right one later, taking into account the timezone?

Answer 1

Store in one UTC format (for example), before adding a task to the database, convert the date to our format

Answer 2

Vladimir Rudnykh, Technical Manager of the Mail.Ru Calendar on Habré wrote a good article on this topic.