Netezza Data Types

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

Netezza Data Type Extensions