Query update Truncated incorrect DOUBLE value

[cms9651]

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);

When adding this line in update query:

 a.C_Int = ROUND(((a.A2 * a.Dur) / 60), 2);

I have this error:

[Err] 1292 - Truncated incorrect DOUBLE value: '111,00'

I tried this query for convert string (varchar) to decimal:

SELECT
	CAST('1.505,00' AS DECIMAL(10, 2)) AS result
FROM
	tbl_a ;

But the result is: 1,51 that is different from 1.505,00...

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

Can you help me?
thank you.