一、时间戳计算前N天后N天并转化为日期，本例是将某个时间戳转为日期，并计算出与该日期前后相差7天的日期：
select DATE_SUB(FROM_UNIXTIME(1577150717, ‘%Y-%m-%d‘),INTERVAL 7 DAY)as ‘before‘,FROM_UNIXTIME(1577150717, ‘%Y-%m-%d‘) as ‘now‘,DATE_ADD(FROM_UNIXTIME(1577150717, ‘%Y-%m-%d‘),INTERVAL 7 DAY)as ‘after‘;
输出：
# before, now, after ‘2019-12-17‘, ‘2019-12-24‘, ‘2019-12-31‘
二、时间戳计算前N天后N天并输出时间戳
select UNIX_TIMESTAMP(DATE_SUB(FROM_UNIXTIME(1577150717),INTERVAL 7 DAY)) as ‘before‘,1577150717 as ‘now‘,UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(1577150717),INTERVAL 7 DAY)) as ‘after‘;
输出：
# before, now, after ‘1576545917‘, ‘1577150717‘, ‘1577755517‘
原文：https://www.cnblogs.com/lyc94620/p/12093385.html