|
|
Posted by MGFoster on 06/02/06 19:10
HandersonVA wrote:
> I choose a price field as a money data type, but I cannot change the
> scale of this.
> the default scale is 4 (it dimmed).
> how can I change to 2? I only need 2 scale such as $23.33 instead of
> $23.3344
>
Use the DECIMAL(<precision>,<scale>) instead of the MONEY data type. E.g.:
sales_price DECIMAL(9,2)
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Navigation:
[Reply to this message]
|