Mysql 时间处理

查询时间超过48小时的数据

SELECT a.* FROM t_member_iccard_info a WHERE (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(a.gmt_modified))/60/60>48 AND a.`status`=4