SELECT UNIX_TIMESTAMP("2016-07-17 23:59:59") select id from table where 1 and atTime>UNIX_TIMESTAMP("2018-04-10");