注意 这里都是 where 查询条件 数据都为时间戳
获取今天的数据
to_days(FROM_UNIXTIME(1641349090,'%Y-%m-%d')) = TO_DAYS(now())
获取本周数据
YEARWEEK(date_format(FROM_UNIXTIME(1641349090,'%Y-%m-%d'),'%Y-%m-%d'),1) = YEARWEEK(now(),1)
获取 上周的数据
YEARWEEK(FROM_UNIXTIME(1640744289,'%Y-%m-%d'),1) = YEARWEEK(DATE_SUB(now(), INTERVAL 1 WEEK),1)
获取本月数据
DATE_FORMAT( FROM_UNIXTIME( '1641290494', '%Y-%m-%d' ), '%Y%m' ) = DATE_FORMAT( CURDATE( ) , '%Y%m' )
获取上月数据
FROM_UNIXTIME( create_time, '%Y-%m' ) = date_format(DATE_SUB(curdate(), INTERVAL 1 MONTH),'%Y-%m')
获取本季度数据
QUARTER(FROM_UNIXTIME(1640744289,'%Y-%m-%d')) = QUARTER(now()) and FROM_UNIXTIME(1640744289,'%Y') = DATE_FORMAT( CURDATE( ) , '%Y' )
获取上季度数据
QUARTER(FROM_UNIXTIME(1640744289,'%Y-%m-%d')) = QUARTER(DATE_SUB(now(),interval 1 QUARTER))
获取本年的数据
YEAR(FROM_UNIXTIME(1640744289,'%Y-%m-%d')) = YEAR(NOW())
获取上年的数据
YEAR(FROM_UNIXTIME(1640744289,'%Y-%m-%d')) = YEAR(DATE_SUB(NOW(),INTERVAL 1 YEAR))