Data Conversion

Question

How do I convert 0.50 to 50 or 0.1429 to 14.29 in sql query? My data type is real.

Answer 1

Multiply by 100.

Answer 2

You can multiply it by 100. : )

I'm not sure exactly what you are doing, but it's like this:

Select 0.50 *100 as MyNewNumber

or

Select MyColumn *100 as MyNewNumber

Answer 3

SELECT (column * 100) FROM TABLE

:)

Answer 4

select 0.50*100

in sort

SELECT (data * 100) 

Answer 5

SELECT u.`value`*100 FROM invoice