Decimal format

altruist · Post by **altruist** » Tue Aug 05, 2014 6:53 am

Hi,

I am slightly confused with decimal format. Can you please clarify the below to me.

DECIMAL[1,0]
Maximum Value = 9.0
Minimum Value = -9.0

DECIMAL[5,2]
Maximum Value = 999.99
Minimum Value = -999.99

Am I right over here?

qt_ky · Post by **qt_ky** » Tue Aug 05, 2014 9:24 am

The first argument is total number of digits. The second argument is number of digits after the decimal point.

altruist · Post by **altruist** » Tue Aug 05, 2014 11:58 am

Does the first argument include or exclude the sign.
DECIMAL[1,0]
Maximum Value = 9.0
Minimum Value = -9.0 OR Minimum Value = 0.0

DECIMAL[5,2]
Maximum Value = 999.99
Minimum Value = -999.99 OR Minimum Value =-99.99

ray.wurlod · Post by **ray.wurlod** » Tue Aug 05, 2014 6:07 pm

The first argument does NOT include the sign. The definition ("digits") is correct.

altruist · Post by **altruist** » Tue Aug 05, 2014 9:17 pm

So in my case, are the highlighted one's the correct values
DECIMAL[1,0]
Maximum Value = 9.0
Minimum Value = -9.0 OR Minimum Value = 0.0

DECIMAL[5,2]
Maximum Value = 999.99
Minimum Value = -999.99 OR Minimum Value =-99.99

ray.wurlod · Post by **ray.wurlod** » Wed Aug 06, 2014 3:43 am

Minimum value for signed decimal[1,0] is -9.0.
Minimum value for unsigned decimal[1,0] is 0.0.
Minimum value for signed decimal[5,2] is -999.99.
Minimum value for unsigned decimal[5,2] is 0.0 (which is the same as 000.00).