mysql - SQL 将 int 转换为日期时间

Question

为什么这个SQL语句:

Select cast(convert(1231231231,103) AS datetime)

导致错误:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '103) AS datetime)' at line 1

我需要将INT转换为DATETIME，如何使其工作？

Answer 1

由于您的整数是unix时间，您可以使用FROM_UNIXTIME(unix_timestamp):https://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_from-unixtime ？