MySQL 联合查询及时间戳转化：
SELECT M21_alert.`customer_ip`,M21_assets.customer_name,M21_assets.device_area,FROM_UNIXTIME(M21_alert.alert_timestamps,'%Y-%m-%d %H:%i:%s') AS alert_timestamps,M21_alert.trigger_description,M21_alert.alert_comment,FROM_UNIXTIME(M21_alert.upgrade_timestamps,'%Y-%m-%d %H:%i:%s') AS upgrade_timestamps,M21_alert.`alert_duration`,M21_alert.`feedback_status`,M21_alert.`feedback_result`,M21_alert.process_staff
from M21_alert,M21_assets where M21_alert.asset_id=M21_assets.id and M21_assets.disabled=0 and M21_alert.alert_timestamps>= 1635696000 and M21_alert.alert_timestamps<1638288000
版权声明：本文为longe20111104原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。