FROM_UNIXTIME(timestamp/1000) SELECT FROM_UNIXTIME(`timestamp`/1000),substr(FROM_UNIXTIME(`timestamp`/1000),1,10),`timestamp` FROM face_event WHERE site_id='dyc_tianjin_nk' AND substr(FROM_UNIXTIME(`timestamp`/1000),1,10)='2020-02-26' limit 100