Price with , in VARCHAR to DECIMAL, MySQL

Price with , in VARCHAR to DECIMAL

Language: Layout:


absolute service time: 10,86 sec

edit mode | history

  
price
REPLACE( price, ',', '' )

1
00
00

2
1.123,45
1.12345

3
100,00
10000

4
123,45.01
12345.01

5
543,21
54321

6
54,300,21
5430021

7
1,12,34,500
11234500

λ

                                      .NET NoSQL database for rapid development