datetime类型的查询
SELECT count(*) from 表名 where (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(modifydate)) > 7776000 and user_id != 0
modifydate字段是datetime类型
(UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(modifydate)) 差值的结果(单位是秒)
datetime类型的查询
SELECT count(*) from 表名 where (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(modifydate)) > 7776000 and user_id != 0
modifydate字段是datetime类型
(UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(modifydate)) 差值的结果(单位是秒)