Converting a string to a double precision in PostgreSQL

Question

How can I convert a string 17,74320512 to a double precision in PostgreSQL ?

I tried:

select cast(`17,74320512` as double precision);

ERROR: invalid syntax for double precision type: '17,74320512'

But i can not change format of the number(17,74320512) because i imported it from .txt file

Jim Jones · Accepted Answer · 2022-08-03 15:01:41Z

1

Use to_number() and chose the format that best suits your strings and locale, e.g.

SELECT 
  to_number('17,74320512','999D99999999'),
  to_number('17,74320512','999D99999999')::double precision;

  to_number  |  to_number  
-------------+-------------
 17.74320512 | 17.74320512

answered Aug 3, 2022 at 15:01

Jim Jones

19.9k3 gold badges44 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Converting a string to a double precision in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related