Posts by Josir • 113 points

• 1

  votes

  1

  answer

  128

  views

  Q: How to use to_number in Postgresql with number in Brazilian format

  I have a column of type text '1534,99', that is with the number in the Portuguese format. How do I use the function to_number in that case? SELECT TO_NUMBER('1534,99','9999999D99') should work if it…

  postgresql

  asked 5 years, 4 months ago Josir 113