Tag Info

New answers tagged


That only applies to TIMESTAMP fields. DATETIME fields are left as-is. See http://dev.mysql.com/doc/refman/5.7/en/datetime.html


I found the solution thanks to this wiki: http://docs.slackware.com/howtos:hardware:syncing_hardware_clock_and_system_local_time Sopping NTP, update time from their servers, restart ntp and synchronize HW clock root@ns226161:~# /etc/init.d/ntp stop Stopping NTP server: ntpd. root@ns226161:~# ntpdate pool.ntp.org 13 May 14:06:12 ntpdate[16434]: step time ...


Some managed switches and routers can actually be used as NTP time servers that might be worth exploring if you don't have a server running 24x7. If you don't have an internet connection the best method is to get an external time source that sets time from a Radio Clock or GPS. Some searching will find dedicated devices in various price ranges or do a ...


mysqld tries to determine your timezone at startup. You can see these values with: SELECT @@global.time_zone, @@session.time_zone; You can set the timezone per-session or globally at runtime: SET GLOBAL time_zone = timezone; You can, and it seems you should, set it in the config file: default-time-zone='+0:00' The documentation says these are valid ...

Top 50 recent answers are included