SQL命令处理数据，时间戳修改成日期格式ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00'

　

0000

sql命令在处理数据时，时间戳修改成日期格式报错：ERROR 1292 (22007): incorrect datetime value: ‘0000-00-00 00:00:00’

退出，进入管理员模式再登录mysql

show variables like 'sql_mode';

退出，再次用管理员权限登录数据库，就可以添加成功了：

参照链接：https://blog.csdn.net/zhengwei125/article/details/79003563/

SQL Error: select * from ***_ecms_news where id<>'60474' and (title like '%ERROR%' or title like '%00%' or title like '%Incorrect%' or title like '%value%' or title like '%'%' or title like '%0000%' or title like '%-%' or title like '%00%' or title like '%-%' or title like '%00%' or title like '%'%' or title like '%'%' or title like '%'%') order by newstime desc limit 5