[MySQL 5] Casting

[SkOrPiOn`87]

SELECT IDConto, SUM(CAST(((quantita*prezzo) - (quantita*prezzo)*sconto/100.00)) AS decimal(10,2)) AS tot FROM prodotti_venduti WHERE id_differita=4433 GROUP BY IDConto



You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS decimal(10,2)) AS tot FROM prodotti_venduti WHERE id_differita=4433 GROUP B' at line 1

[chris]

CAST( pippo AS formato )
http://dev.mysql.com/doc/refman/5.0/...#function_cast

hai messo "AS decimal" fuori dalla funzione CAST

[piero.mac]

potresti anche semplificare:

SUM(CAST(quantita * (prezzo - prezzo * sconto/100.00) AS decimal(10,2))) AS tot