Today I used the MySQL convert_tz function.

Before I could use named timezones with convert_tz I had to load the timezones.