> I've no idea what ``SET time_zone`` does, but I'm guessing it's > setting the time_zone for the whole database or a table? Or is it > something on DBMS level (like for the whole MySQL installation)? Or on > connection-level? >
According to http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html it will set per-connection time zone. I need this to store and retrieve TIMESTAMP values in local timezone. By default, Mysql timezone = server system timezone, which is different from my local timezone. -- You received this message because you are subscribed to the Google Groups "web.py" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/webpy?hl=en.
