-------------------------------------+
03
| UNIX_TIMESTAMP('2005-03-27 03:00:00') |
04
+---------------------------------------+
05
| 1111885200 |
06
+---------------------------------------+
07
mysql> SELECT UNIX_TIMESTAMP('2005-03-27 02:00:00');
08
+---------------------------------------+
09
| UNIX_TIMESTAMP('2005-03-27 02:00:00') |
10
+---------------------------------------+
11
| 1111885200 |
12
+---------------------------------------+
13
mysql> SELECT FROM_UNIXTIME(1111885200);
14 www.2cto.com
+---------------------------+
15
| FROM_UNIXTIME(1111885200) |
16
+---------------------------+
17
| 2005-03-27 03:00:00 |
18
+---------------------------+
参考链接： https://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_unix-timestamp
作者 Bairrfhoinn