List:General Discussion« Previous MessageNext Message »
From:Brent Baisley Date:July 28 2009 1:29pm
Subject:Re: store timezone
View as plain text  
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<manojsingh2121@stripped> 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
store timezoneManoj Singh28 Jul
  • Re: store timezoneBrent Baisley28 Jul
    • Re: store timezoneJohnny Withers28 Jul