mysql及date时间戳与标准时间转换

mysql时间戳与标准时间转换

mysql> select FROM_UNIXTIME("1290214840");
+-----------------------------+
| FROM_UNIXTIME("1290214840") |
+-----------------------------+
| 2010-11-20 09:00:40         |
+-----------------------------+
1 row in set (0.03 sec)

标准时间 to 时间戳
UNIX_TIMESTAMP('YYYY-MM-DD HH:MM:SS'');

mysql> select UNIX_TIMESTAMP("2010-11-20 09:00:40"); 
+---------------------------------------+
| UNIX_TIMESTAMP("2010-11-20 09:00:40") |
+---------------------------------------+
|                            1290214840 |
+---------------------------------------+
1 row in set (0.02 sec)

date时间戳与标准时间转换

# date  -d "2010-12-31 12:45:20" +%s 
# 1293770720