List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:July 28 2009 1:59pm
Subject:Re: store timezone
View as plain text  
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 <brenttech@stripped> 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<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
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
-----------------------------
Johnny Withers
601.209.4985
johnny@stripped

Thread
store timezoneManoj Singh28 Jul
  • Re: store timezoneBrent Baisley28 Jul
    • Re: store timezoneJohnny Withers28 Jul