1.转换时间为timestamp: select UNIX_TIMESTAMP(badcase_time)*1000 badcase_time from badcase_record_history where datekey in (20190507)