MySQL Convert Datetime field in UTC Timezone to Brisbane Australia

CONVERT_TZ() makes you happy to keep your server on UTC while you sit in Brisbane eating Yatala Pie wrote this over 2 years ago and it was last updated about 2 years ago.

← Back to the Posts

CONVERT_TZ(created_at, 'UTC', 'Australia/Brisbane') AS created_at