Netezza Data Types

Posted: September 21, 2014 in Netezza
BYTEINT 8-bit values in range –128 to 127
SMALLINT 16-bit values in range –32,768 to 32,767
INTEGER 32-bit values in range –2,147,483,648 to 2,147,483,647
BIGINT 64-bit values in range -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
NUMERIC(p,s)/DECIMAL Numeric with precision p and scale s. Precision can range from 1 to 38, scale from 0 to the precision
FLOAT(p)/REAL Floating point number with precision p, from 1 to 15
CHAR(n) Fixed length string, maximum 64,000
VARCHAR(n) Variable length string, maximum 64,000
BOOLEAN With value true (T) or false (F)
TIMESTAMP (DATE/TIME) Ranging from January 1, 0001 00:00:00.000000 to December 31, 9999 23:59:59.999999
Listed above are the data types that you can utilize in Netezza.

Netezza Data Types in More Detail

image

Netezza Data Type Extensions

image
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s