获取当天0点0分0秒（midnight）的时间戳

select unix_timestamp(curdate());

获取前7天的时间戳

select unix_timestamp( curdate() ) - (86400 * 7);

获取今天0点到现在的数据

时间字段create_time的数据格式是int

select * from table_name where create_time >= unix_timestamp(curdate()) and create_time <  unix_timestamp();

获取7天前的记录(不包括今天)

时间字段create_time的数据格式是int

select * from table_name where create_time >= (unix_timestamp(curdate()) - (86400 * 7)) and create_time  < unix_timestamp(curdate());

获取7天前的数据(包括今天)

时间字段create_time的数据格式是int

select * from table_name where create_time >= (unix_timestamp(curdate()) - (86400 * 7)) and create_time  < unix_timestamp();

获取1个月前（前30天）的数据(包括今天)

时间字段create_time的数据格式是int

select * from table_name whwre create_time >= (unix_timestamp(curdate()) - 86400*30) and create_time < unix_timestamp();

获取1个月前（前30天）的数据(不包括今天)

时间字段create_time的数据格式是int

select * from table_name whwre create_time >= (unix_timestamp(curdate()) - 86400*30) and create_time < unix_timestamp(curdate());