Replace the comma with period in database

Hi, thanks in advance to all.

I started my application using the default language of Argentine Spanish, I noticed that the app started saving the decimals using a comma. For example, 456.5 saves it as 456,5.

This started to give me problems when I was trying to calculate expressions (with the toolbox plugin) to calculate some things using rates that I bring from an API.

The point is that I am trying to make my database save the numbers again with periods/ dot and not with a comma.

I hope I have explained myself and I will really be very grateful for the help you can give me.

Have you tried format as after the condition and then select decimals?

1 Like