Talk:MySQL/Language/Data Types

There is a difference between DATETIME and TIMESTAMP: A TIMESTAMP is stored in UTC and converted to/from the local timezone when it is accessed while DATETIME is stored without timezone information. This means that in timezones applying dayight saving time, there are points in time occuring twice during the night when a timezone switch to or from daylight saving time. With DATETIME, it is not possible tell e.g. the first and the second 2:30 AM apart. Also, if the server's timezone changes, you might have problems. -- Viktor, 176.71.67.186 (discuss) 18:44, 2 November 2014 (UTC)