I use a float as a datatype. However, I want to limit the number of placeholders after the decimal to 2. I can't seem to accomplish this.
For example, I want to cut the number: 4.45454545 down to just 4.45.
I indicated the length of the number, but it doesn't work.
CAST (expression as float(10)
? Is it possible to cast a number to a decimal of two places after the decimal. I want to limit the number of decimals that come after the decimal to 2.
Any help will be appreciated. I'm still learning how to write sql expressions.