Time zones are always tricky. Luckily Coordinated Universal Time (UTC) makes it easy to get your local time even if your database is hosted on the other side of the world.
The code below returns the local time in New Zealand.
SELECT CONVERT_TZ( UTC_TIMESTAMP( ) , 'UTC', 'NZ' );
Related Posts
Simple MySql data to XML with PHP
HTML Problem Finder
Easiest Python Integrated Development Environment (IDE) – PyCharm
Programming hundreds of Arduino Minions in one go
Blender – The next step after Sketchup
OpenSCAD – Using extrusions to make rounded shapes
Arduino – HTTP Post Requests
Raspberry Pi – Automating things with BASH scripts
One Thought on “MYSQL – Getting Your Local Time”