MySQL依据时间格式筛选WHERE

• 问题描述

  依据datetime时间格式筛选。

• 解决方案

• 格式转换

  SELECT FROM_UNIXTIME(1563255818,"%Y-%m-%d %H:%i:%s") as time;
  

• datetime

  SELECT * FROM web_attack_ip WHERE UNIX_TIMESTAMP(attack_time) BETWEEN UNIX_TIMESTAMP('2017-08-10 14:48:29') AND UNIX_TIMESTAMP