store timezone

--00163630f2c19beb4d046fc2cd05
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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

--00163630f2c19beb4d046fc2cd05--

Re: store timezone

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 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=gcdmg-mysql-2@m.gmane.org

Re: store timezone

--0016e6db6c094c6807046fc47909
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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 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
> 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=johnny@pixelated.net
>
>


--
-----------------------------
Johnny Withers
601.209.4985
johnny@pixelated.net

--0016e6db6c094c6807046fc47909--