mysql的错误1292_Mysql错误代码：1292日期时间值不正确：'' (Mysql Error Code : 1292 Incorrect datetime value : '')...

作者：盐析白兔 | 2024-05-22 07:31:59

踩

error code: 1292. incorrect date value: '' for column '有效期' at row 192

2014-03-21 16:36:54

I'm trying to insert a record to a table and I get the following error.

Mysql Error Code : 1292 Incorrect datetime value : ''

Mysql code snip-let is as follows

INSERT INTO tbl_dashboard (avg_response)

SELECT cast(ifnull(floor(avg(5 * (DATEDIFF(substring(im.inq_managerreply,-10), im.inq_managerdate) DIV 7)

+ MID('0123444401233334012222340111123400001234000123440',

7 * WEEKDAY(im.inq_managerdate) + WEEKDAY(substring(im.inq_managerreply,-10)) + 1, 1))),'not_applicable')AS CHAR(45)) 'average_response_time_in_working_days'

FROM inq_manager im

There are no errors in executing the select statement which gives the average response time excluding the weekends but when I try to insert the above to my table the error is given.

The data type of the tbl_dashboard is avg_response char(45)

How can I overcome this . Please help

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/盐析白兔/article/detail/607169