1.select * from order where paytime>=UNIX_TIMESTAMP('2011-3-1') and paytime<=UNIX_TIMESTAMP('2011-3-31')
2.查询出当月字段:
SELECT *
FROM `table`
WHERE month( from_unixtime(时间字段)) = month( now( ) ) and year(from_unixtime(时间))=year(now());
时间格式为1219876…… UNIX时间,只要应用“FROM_UNIXTIME( )”函数