I have a small problem with a short memory.
I know it is simple I just can’t find or remember it.

I need my currency figures in my database to show both decimal spots i.e.

12.10 not 12.1 or 12.00 not 12.0

I am using decimal 8,2 but that isn’t the whole answer.
Any suggestions well be welcome… :confused:

this is the responsibility of the application program

the database has the correct data – the application formats it for cosmetic purposes

DUH,… you are right.
It needs to be in my request with my php code,…
Thanks for jogging my memory,…