Agreed. Store as UTC. You can always convert to the needed timezone during query or during display. See MySQL's CONVERT_TZ() function.
On Tue, Jul 28, 2009 at 8:29 AM, Brent Baisley <brentt...@gmail.com> wrote: > 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=joh...@pixelated.net > > -- ----------------------------- Johnny Withers 601.209.4985 joh...@pixelated.net