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>
> > Hi All,
> > Is it possible to store the timezone with datetime data type in mysql or
> > 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