mysql中把字符串转成时间戳进行对比 SELECT UNIX_TIMESTAMP("2016-07-17 23:59:59") select id from table where 1 and atTime>UNIX_TIMESTAMP("2018-04-10");