Home How to convert numeric quantity from European style to American style
Reply: 1

How to convert numeric quantity from European style to American style

DarthVoid
1#
DarthVoid Published in 2018-01-12 16:28:11Z

I have a sql query that is reading values like 1.000.000,000 (EU 1 million) from a table. I need the query to interpret these as 1,000,000.000 (American 1 million). How do I do this?

Bibin Matthew
2#
Bibin Matthew Reply to 2018-01-12 16:33:54Z

You can do this way

 SELECT CAST(REPLACE(REPLACE('523,916','.',''), ',','.') AS NUMERIC(20,2));
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.317319 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO