how to store timezone in a table
Posted: Tue Aug 17, 2004 3:08 am
Hello
I have a table which stores an attribute of type DATETIME. I would also like to know what timezone this type represents. Does the DATETIME type implicitly stores the timezone of a value or do I need to store it separately in a separate attribute? If so, what type should the timezone be stored at?
CREATE TABLE time_info (
time DATETIME NOT NULL,
timezone <type ?>
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
regards
Jason
I have a table which stores an attribute of type DATETIME. I would also like to know what timezone this type represents. Does the DATETIME type implicitly stores the timezone of a value or do I need to store it separately in a separate attribute? If so, what type should the timezone be stored at?
CREATE TABLE time_info (
time DATETIME NOT NULL,
timezone <type ?>
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
regards
Jason