01 Dec 08 MySQL Casting Gotcha
Works
SELECT 409.95 = (1 + 408.95)
Doesn't
SELECT 409.95 = (a + b)
Works
SELECT 409.95 = CAST((a + b) AS decimal)
Leave a Comment
Flickr
Works
SELECT 409.95 = (1 + 408.95)
Doesn't
SELECT 409.95 = (a + b)
Works
SELECT 409.95 = CAST((a + b) AS decimal)