What values goes into decimal data types

[#1]

I am from sql server background haven't used a datatype decimal 13,2

what values goes inbto decimal 13,2

please kindly explain.

Thanks a lot for the helpful info.

[Former Member]

Hi Rogers,

Decimal 13,2 represents value will be of length 13 and will be up to 2 decimal places.

for e.g - if u have value 1234567891234.426789

above data type will show you value -1234567891234.43

i hope, this is what you are asking......

Thnkss

Kulwinder

[anilreddyk]

HI Kulwinder,

Seems your explanation is in correct.

The DEC Data Type holds total number of digits as defined as precision (including the scale).

That means,

Decimal 13,2 represents Total value will be of length 13 including 2 decimal places.

for e.g:

1. if u have value 1234567891234.426789

above data type will show you value as: 1234567891234

2. if u have value 12345678901.426789

above data type will show you value as: 12345678901.42

(Please correct me if I'm wrong here).

Regards,

Anil.K