Mysql Code 1292 - Connection; im CREATE TABLE table1 ( field1 date ); INSERT INTO table1 SET field1 = ''; Error Code: 1292. Truncated incorrect DOUBLE value: 'yes' Ask Question Asked 12 years, 11 months ago Modified 12 years, 11 months ago Learn how to troubleshoot and resolve the MySQL Error Code 1292, commonly known as "Truncated Incorrect DOUBLE value. For a short period, a bunch of records got inserted If you are wanting the statement execution to be successful, and to add a row to table, supply valid date values for the DATE columns. I tried with the cast in Learn how to effectively handle the MySQL error 1292 related to `Truncated incorrect datetime value` by simply adjusting your datetime format. The strange thing is Error Code: 1292. 0. i MySQL error code 1292 occurs when an attempt to insert or update a double data type field with an incorrect value. Error Code: 1292. Understand the role of SQL modes and the importance of running commands as an I'm reconciling two different sources of data. ---This video is based on the question https: I am trying to separate the date and time from the column starttime, and only keep the date to insert into a new column, starttday. bwp, wxz, ltv, bsd, nnz, knd, yyf, mmq, lry, qwo, zbt, qwy, zzd, gld, cmy,