摘要:
下文讲述mysql数据库中获取unix指定时间的方法分享,如下所示;
实现思路:
1.借助now获取当天日期及时间
2.借助ADDDATE函数向前减去指定天数
3.使用unix_timestamp()方法转换时间类型
例:
mysql> select unix_timestamp(adddate(now(),interval -60 day));
+-------------------------------------------------+
| unix_timestamp(adddate(now(),interval -60 day)) |
+-------------------------------------------------+
| 1592746019 |
+-------------------------------------------------+
1 row in set (0.00 sec)
mysql> select adddate(now(),interval -60 day);
+---------------------------------+
| adddate(now(),interval -60 day) |
+---------------------------------+
| 2020-06-21 21:27:11 |
+---------------------------------+
1 row in set (0.00 sec)