Mysql Datetime with Time zone

Question

Hi All,

I need a help in how to store datetime along with timezone. i am using Mysql 5.1. i want to do something like -

create table tb1
(
c1 datetime with time zone
);

Answer 1

Save the timezone in an extra column or do the conversion before saving the datetime value depending on your needs.

Starting from Mysql 4.1.3 you can use the CONVERT_TZ() function