Bug #68931 | saving some timestamp values are incorrect in mysql 5.5.29 | ||
---|---|---|---|
Submitted: | 11 Apr 2013 10:49 | Modified: | 12 Apr 2013 12:12 |
Reporter: | sedat sevgili | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Data Types | Severity: | S3 (Non-critical) |
Version: | 5.5.29 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | timestamp insert |
[11 Apr 2013 10:49]
sedat sevgili
[11 Apr 2013 10:50]
sedat sevgili
Furthermore, in mysql 5.5.16, it saves correctly.
[11 Apr 2013 11:02]
Shane Bester
looks simply like DST issue to me?
[11 Apr 2013 11:12]
Miguel Solorzano
Please check your DST how Shane commented. Thanks.
[11 Apr 2013 11:15]
sedat sevgili
when i run "SELECT COUNT(*) FROM mysql.time_zone_name;" it gives 0 to me. Are there any way to check my dst of my server?
[11 Apr 2013 11:36]
sedat sevgili
my time related variables are: datetime_format => %Y-%m-%d %H:%i:%s lc_time_names => en_US system_time_zone => EEST time_format => %H:%i:%s time_zone => SYSTEM
[11 Apr 2013 17:44]
Miguel Solorzano
Please check the Daylight Save Time for EEST.
[12 Apr 2013 12:10]
sedat sevgili
so, is there any way to fetch always what i write with timestamp, whatever my eest setting is?
[12 Apr 2013 12:12]
sedat sevgili
and also isn't interesting that when we use mysql 5.5.16 this issue doesnt arise?