CONVERT_TZ() makes you happy to keep your server on UTC while you sit in Brisbane eating Yatala Pie
me@jaykilleen.com wrote this about 4 years ago and it was last updated almost 4 years ago.
CONVERT_TZ(created_at, 'UTC', 'Australia/Brisbane') AS created_at