MySQL doesn't support timezones (I think Postgres does). I usually just store dates as Greenwich Mean Time and store the time zone hours offset in a separate field.
Brent Baisley On Tue, Jul 28, 2009 at 7:59 AM, Manoj Singh<manojsingh2...@gmail.com> wrote: > Hi All, > > Is it possible to store the timezone with datetime data type in mysql or any > other approach available to achieve this in mysql. > > Looking for your help. > > Thanks, > Manoj > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org