All the time, timestamp and datetime fields are producing some unexpected
results.
When I insert a row, assigning NOW() to a field of those types, it's
showing up in the PST timezone. My ISP is in the EST timezone and when I
look at the timezone of the server where mySQL is installed is showing up
in UTC.
When I query this table, is there a way I can specify the timezone offset?
Will I have to use ADDDATE / SUBDATE? Can each SQL user set their timezone
perferenes?