mysql> select from_unixtime(1546322400) as date;
+---------------------+
| date |
+---------------------+
| 2018-12-31 22:00:00 |
+---------------------+
mysql> select date_format(from_unixtime(1546322400), '%m/%d/%Y') as date;
+------------+
| date |
+------------+
| 12/31/2018 |
+------------+
我忘记了,直到上面nbk的注释中,来自_UNIXTIME()的注释确实支持可选的第二个参数,所以您可以通过一个步骤来完成:
mysql> select from_unixtime(1546322400, '%m/%d/%Y') as date;
+------------+
| date |
+------------+
| 12/31/2018 |
+------------+
阅读大约DATE_FORMAT()篇