Query data by time (the time storage format is unix timestamp)

Query data by time (the time storage FORMAT is unix timestamp) without SELECT * FROM 'pre _ common_member_log_w 'WHEREDATE _ FORMAT (FROM_UNIXTIME (dateline ), % Y-% m-% d) DATE_FORMAT (NOW (), % Y-% m-% d) LIMIT0, 30SELECT * FROM 'pre _ common_member_log_w 'WHEREDA

Query data by time (the time storage format is unix timestamp) without SELECT * FROM 'pre _ common_member_log_w 'WHERE DATE_FORMAT (FROM_UNIXTIME (dateline ), '% Y-% m-% D') = DATE_FORMAT (NOW (),' % Y-% m-% D') LIMIT 0, 30 SELECT * FROM 'pre _ common_member_log_w 'WHERE DA

Query data by time (the time storage format is unix timestamp) <无>

SELECT *FROM `pre_common_member_log_w`WHERE DATE_FORMAT( FROM_UNIXTIME( dateline ) , '%Y-%m-%d' ) = DATE_FORMAT( NOW( ) , '%Y-%m-%d' )LIMIT 0 , 30SELECT *FROM `pre_common_member_log_w`WHERE DATE_FORMAT( FROM_UNIXTIME( dateline ) , '%Y-%m-%d' ) = '2014-10-23'LIMIT 0 , 30SELECT DATE_FORMAT( FROM_UNIXTIME( dateline ) , '%Y-%m-%d' ) AS mytime, titleFROM `pre_common_member_log_w`WHERE DATE_FORMAT( FROM_UNIXTIME( dateline ) , '%Y-%m-%d' ) = '2014-10-23'LIMIT 0 , 30