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

me@jaykilleen.com wrote this over 3 years ago and it was last updated over 3 years ago.

utc timezone sql

← Back to the Posts

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

Similar

[SOLVED] Resync Postgresql tables primary key

Blank Power Query Template for a Raw SQL Query using Microsoft SQL Server

Extract Multiple Product Hierarchy Levels from an SAP Product Hierarchy Key

Using SQL to Convert Date to Financial Period Key

Blank Power Query Template for a Raw SQL Query

Rails new with Webpacker, Vue and Postgres

[SOLVED] SQL Get Financial Year from Date

Using VS Code Extension MSSQL instead of Excel Power Query for Easy Database Querying

Display a SQL Server Table Schema in PowerBI

Cheatsheet for Running SQL Against PostgreSQL from the Command Line