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
Originally Posted by CowboyTed
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,....