What is the difference between MySQL datetime and SQL Server datetime?
Copyright Notice: This article is an original work licensed under the CC 4.0 BY-NC-ND license.
If you wish to repost this article, please include the original source link and this copyright notice.
Source link: https://v2know.com/article/498
Let me start with the conclusion: there is no difference.
Someone told me before that when importing sqlserver database into mysql, pay attention that Datetime will become varchar, and you can change it to timestamp.
What is the difference between mysql's timestamp and datetime?
DateTime and TimeStamp are both year, month, day, hour, minute and second, why are there these two types?
The biggest difference between DateTime and TimeStamp is only in the different scenarios. If your application is used in different time zones (that is, both domestic and foreign), various problems will occur if you use dateTime, but if you use TimeStamp, There will be no such time difference.
Previously, I also considered datetime and TimeStamp to be the same, because their data inventory time is in YYYY-MM-DD HH:mm:ss format, but the TimeStamp type stores a 10-digit or 13-digit timestamp.
This article was last edited at 2020-11-04 16:08:29