CODEWITHSUNDEEP
sqlamazon-redshift
user8834780
user8834780

Reputation: 1670

Float to percentage

I am trying to convert the likes of 0.004 to 0.4% (call it bill_rate). Is there a built in function for percentage, or any easy way to do that?

Upvotes: 1

Views: 1312

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269503

Well, there is * 100. I think you want:

select to_char(bill_rate * 100, '0.0') || '%'

Upvotes: 2

Related Questions