MySQL Forums
Forum List  »  General

Re: Probable timezone problems: can anyone confirm and offer a solution?
Posted by: Ted Byers
Date: March 21, 2014 08:04PM

Thanks Rick. I guess I will be editing my.cnf soon, to set the timezone MySQL uses to UTC (and I assume there is no harm done in leaving the system timezone alone).

All of my tables with fields that take a timestamp have the fields defined as TIMESTAMP, and TIMESTAMP('yyyy-mm-dd hh:mm:ss') is used to insert the timestamps. And my perl code takes the current timestamp, using the local timezone and converts it to UTC before trying to store it. So, would it be rational to hope that the historical data is not especially messed up, and that my principle problem is one of timestamps that were deemed to be invalid because MySQL didn't know that the timestamps are defined as UTC (and I didn't know how to tell it what timezone ttthe timestamps is defined in).

Thanks again

Ted

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.