2

I'm doing astored procedure using a MySQL database. How could I round or truncate a FLOAT variable with diferent decimals?

I've found this answer: Truncate (not round) decimal places in SQL Server

Are any solution using just PL, not PL/SQL?

Thanks anyway.

Community
  • 1
  • 1
dmunozpa
  • 131
  • 1
  • 7
  • Finally done, I'm using another variable DECIMAL(10,n) where n is the number of decimals. For example: SET var DECIMAL(10,2) DEFAULT 5,50; – dmunozpa Dec 20 '11 at 07:44

0 Answers0