一、shell中求时间戳:
#date +%s
[oracle@henry-linux01 ~]$ date +%s
1484814460
[oracle@henry-linux01 ~]$ date -d"2017-01-19 00:00:10" +%s
1484755210
shell中时间戳换算成时间:
[oracle@henry-linux01 ~]$ date -d@1484813383 +"%Y-%m-%d %H:%M:%S"
2017-01-19 16:09:43
[oracle@henry-linux01 ~]$ date -d@1484814460
Thu Jan 19 16:27:40 CST 2017
二、mysql数据库中求时间戳
mysql> select unix_timestamp(now());
+-----------------------+
| unix_timestamp(now()) |
+-----------------------+
| 1484815072 |
+-----------------------+
1 row in set (0.00 sec)
mysql中根据时间戳换算成时间时期
mysql> select from_unixtime(1484815072);
+---------------------------+
| from_unixtime(1484815072) |
+---------------------------+
| 2017-01-19 16:37:52 |
+---------------------------+
1 row in set (0.00 sec)