470,614 Members | 1,429 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

time question

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
0 1172

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Valiz | last post: by
2 posts views Thread by Steve Miller | last post: by
14 posts views Thread by George | last post: by
1 post views Thread by Rob T | last post: by
15 posts views Thread by Oleg Leikin | last post: by
9 posts views Thread by FFMG | last post: by
6 posts views Thread by Geoff Cox | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.