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
how to store timezone in a table
Moderator: General Moderators
-
litebearer
- Forum Contributor
- Posts: 194
- Joined: Sat Mar 27, 2004 5:54 am