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
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 d
