[SOLVED] SQL number formats?

[Miko]

Hello,

 

I have some values in a column, these values are prices/amounts, something like this: 1400,63.

Now I would like to make the SUM from some values, so my query should be like:

 

SELECT SUM(AMOUNT)FROM table

 

So assuming that I have 1400,63 and 1200,31 in my table, than the SUM result should be: 2631,63

 

But what I get is 2631 without the 2 numbers after the comma.

This is very important since the data in the database is real data from invoices etc ... .

Maybe a setting of my column?

 

Anyone?

[GingerRobot]

I'm unsure about the locale settings MySQL offers, but i'm guessing that if you have a comma as your decimal separator then you're storing these values as a varchar or similar? You should be using a decimal field and formatting for output at the end.

[Miko]

Correct, I changed the , into .

 

Thanks