Netezza Connector > Data type reference > Netezza and transformation data types
  

Netezza and transformation data types

The following table lists the Netezza data types that the runtime environment supports and the corresponding transformation data types:
Netezza Datatype
Range
Transformation Datatype
Range
BigInt
Precision 19, scale 0
Bigint
From -9,223,372,036,854,775,808 through 9,223,372,036,854,775,807
Precision of 19, scale of 0 Integer value
Bool
True or false, on or off, 0 or 1, yes or no
String
Precision 1
ByteInt
Precision 3, scale 0
Small Integer
Precision 5, scale 0
Char
Single character
String
From 1 through 104,857,600 characters
Date
ANSI SQL date
Date/Time
Jan. 1, 0001 A.D. to Dec. 31, 9999 A.D.
(precision to the nanosecond)
Float8
Precision 15
Double
Precision 15
Float4
Precision 6, scale 0
Double
Precision 15
Integer
Precision 10, scale 0
Integer
Precision 10, scale 0
NChar(m)
Single character
Used for storing UTF-8 data
nString
From 1 through 104,857,600 characters
NVarchar(m)
BVarchar (length)
Non-blank-padded string, variable storage length
Used for storing UTF-8 data
nString
From 1 through 104,857,600 characters
Numeric
Numeric (precision, decimal), arbitrary precision number
Precision must be between 1 and 38
Decimal
Precision from 1 through 28 digits, scale from 0 through 28
Real
Precision 6, scale 0
Real
Precision of 7, scale of 0
Double-precision floating-point numeric value
SmallInt
Precision 5, scale 0
Small Integer
Precision 5, scale 0
Time
hh:mm:ss. ANSI SQL time
Date/Time
Jan. 1, 0001 A.D. to Dec. 31, 9999 A.D.
(precision to the microsecond)
Timestamp
Precision 26, scale 6
Date/Time
Jan. 1, 0001 A.D. to Dec. 31, 9999 A.D.
(precision to the microsecond)
Varchar
Varchar (length)
Non-blank-padded string, variable storage length
String
From 1 through 104,857,600 characters