Results 1 to 5 of 5
Jan 25, 2013, 05:02 #1
Query update Truncated incorrect DOUBLE value
Hi all, hope in your help.
I need update the table tbl_a with this query:
UPDATE tbl_a a JOIN tbl_ca ca ON a.XYZ = ca.XYZ JOIN tbl_cb cb ON a.Amb = cb.Amb SET a.Amb = ca.Amb, a.Dur = cb.Dur, a.C_Int = ROUND(((a.A2 * a.Dur) / 60), 2);
a.C_Int = ROUND(((a.A2 * a.Dur) / 60), 2);
[Err] 1292 - Truncated incorrect DOUBLE value: '111,00'
SELECT CAST('1.505,00' AS DECIMAL(10, 2)) AS result FROM tbl_a ;
these are the fields of the table but I can not edit directly in the table:
Dur decimal 10,2 C_Int varchar, 255 A2 varchar, 255
thank you.Thanks you very much for your help
I'm really happy for your quickly answer.