MySQL function to convert UTC Time String to DATETIME

Question

Is there any MYSQL function available to convert UTC Time String with TimeZone to DATETIME?

Ex: 2013-05-16T13:15:30Z

Cheers;

Answer 1

you can use convert_tz directly on that timestamp:

select T,
  cast(T as datetime),  -- to cast 
  convert_tz(T, '+00:00', '+08:00')   -- to convert to local time
from 
  (select '2013-05-16T13:15:30Z' T) D

Depending upon your MySQL configuration you may be able to use @@session.time_zone to make the above +08:00 less static