One of my user wants this format 00.00 when cash is equal to 0 instead of 0.00
at the moment i got
to_char(:price,'90.00')
was going to do something like this but it feels very stupid.(Range is 0 - 99.99)
decode(to_char(:price,'90.00'),'0.00','00.00',to_char(:price,'90.00'))
*Side question.... i might try to talk the person out of it because i never seen a numeric number being 00.00 before. Is 00.00 even consider standard?