By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,514 Members | 794 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,514 IT Pros & Developers. It's quick & easy.

time question

P: n/a
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?
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.