Decimal Datatype question. 1

[CapsuleCorpJX]

so does Decimal(9,2)

Mean

[Up to 7 digits].[Up to 2 digits]
With the negative and period being optional?

Or does it mean that the number of chars in the entire thing can't be more than 9, with at most 2 to the right of the decimal so:

-[5 digits].[2 digits]
and [6 digits].[2 digits]
and [7 digits].[1 digit]
all = to 9 max?

 

[dnoeth]

sign + up to 7 digits + decimal point + up to 2 digits

Why don't you simply try it?

Dieter

 

[CapsuleCorpJX]

Eh I don't have access to the Teradata development area yet. They are still setting it up. Working on some pre-prep stuff for now.

 

[tdatgod]

Order a DEMO CD and install it on your personal PC and play with Teradata.

Granted the DEMO is V2r5 based which may be older that what you are getting installed.

http://www.teradata.com/t/page/44749/index.html

but at least you could play with it in the mean time.

The DEMO CD is a fully functional Copy Of Teradata with a SIZE limitation.