Re: NUMBER Vs NUMBER(38)

From: <sergey_s_at_my-deja.com>
Date: Sat, 28 Aug 1999 03:26:18 GMT
Message-ID: <7q7ksl$j7o$1@nnrp1.deja.com>

If I remember this correctly, PRECISION is the number of digits to the right of a decimal point. SCALE is the total number of digits to the left AND right of the decimal point.

Am I right?

Sergey

> > Am I the only one who thinks that the terms precision and scale
> > would be better swapped?
> > Scale to me is the number to the left of the decimal
> > and precision is the number of decimal places.
> > It just sits better with me.
> > Steve
> > --
> > Please remove nospam from my address to Reply.
> >
> Steve,
>
> even i think the same!
> PRECISION should mean the number of decimal places!
> i often get confused between scale and precision.
> --
> Nandakumar
> (N.Kumar_at_rocketmail.com)
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 27 1999 - 22:26:18 CDT