12.7 Date and Time Functions - MySQL

CONVERT_TZ(), Convert from one timezone to another ... This means that multiple references to a function such as NOW() within a single query always produce ...

dev.mysql.com