time question - 03-07-2004 , 09:31 AM
All the time, timestamp and datetime fields are producing some unexpected
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
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