Reputation: 1575

Data Conversion

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

Upvotes: 0

Answers (5)

Reputation: 47532

SELECT u.`value`*100 FROM invoice

Upvotes: 1

Reputation: 176956

select 0.50*100

in sort

SELECT (data * 100)

Upvotes: 1

Reputation: 3217

SELECT (column * 100) FROM TABLE

Upvotes: 1

Reputation: 15041

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

Select MyColumn *100 as MyNewNumber

Upvotes: 2

Reputation: 115867

Multiply by 100.

Upvotes: 4