Обсуждение: float formating with xx.00

Hy,

I am trying to enter 19.00 in a float field... no error but the data (select)
is showing 19  without the "trailing" zeros...  But for format and standard
presentation of money, I need to keep any last zero digit.

How can I do this? I run version 7.1x
Thanks!
--
Mark

On Thursday 03 Jul 2003 8:42 pm, Mark wrote:
> Hy,
>
> I am trying to enter 19.00 in a float field... no error but the data
> (select) is showing 19  without the "trailing" zeros...  But for format and
> standard presentation of money, I need to keep any last zero digit.
>
> How can I do this? I run version 7.1x
> Thanks!

Consider using the numeric type, or you can cast to it for output.

select 19::numeric(9,2);
 numeric
---------
   19.00

--
  Richard Huxton