Wednesday, September 12, 2012

Convert time from a specific timezone to another using CONVERT_TZ()

In this scenario, we have to convert a timezone from Central USA to Hongkong time. I took note of DST here from (-06:00) to (-05:00). Here's a sample query.
SELECT CONVERT_TZ('2012-09-12 04:35:00', '-05:00', '+08:00') as convert_to_ph;
Cheers!

0 comments:

Post a Comment