mysql计算这个月与上个月一号的时间缀
这个月:
unix_timestamp(date_sub(curdate(),interval day(curdate()) - 1 day));
上个月:
unix_timestamp(date_sub(date_sub(curdate(),interval day(curdate()) - 1 day),interval 1 month));
这个月:
unix_timestamp(date_sub(curdate(),interval day(curdate()) - 1 day));
上个月:
unix_timestamp(date_sub(date_sub(curdate(),interval day(curdate()) - 1 day),interval 1 month));