I have a table of double precision values, and I need to insert new values calculated from strings with numeric meaning.
MySQL doesn't seem to allow such conversion:
select cast('3.33' as double);
(error)
select cast('3.33' as decimal(3,2));
(works, but it's not what I need).
Workaround:
select '3.33' + 0.0;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With