netezza data types table

TYPE_NAME	DATA_TYPE	PRECISION	NULLABLE	CASE_SENSITIVE	MAXIMUM_SCALE
NVARCHAR	-9 [NVARCHAR]	16000	TRUE	TRUE	0
NCHAR	-8 [ROWID]	16000	TRUE	TRUE	0
BOOLEAN	-7 [BIT]	1	TRUE	FALSE	0
BYTEINT	-6 [TINYINT]	4	TRUE	FALSE	0
BIGINT	-5 [BIGINT]	20	TRUE	FALSE	0
CHAR	1 [CHAR]	64000	TRUE	TRUE	0
NUMERIC	2 [NUMERIC]	38	TRUE	FALSE	37
DECIMAL	3 [DECIMAL]	38	TRUE	FALSE	37
INTEGER	4 [INTEGER]	11	TRUE	FALSE	0
SMALLINT	5 [SMALLINT]	6	TRUE	FALSE	0
FLOAT	6 [FLOAT]	7	TRUE	FALSE	6
REAL	7 [REAL]	7	TRUE	FALSE	14
DOUBLE	8 [DOUBLE]	15	TRUE	FALSE	14
VARCHAR	12 [VARCHAR]	64000	TRUE	TRUE	0
DATE	91 [DATE]	10	TRUE	FALSE	0
TIME	92 [TIME]	15	TRUE	FALSE	6
TIMESTAMP	93 [TIMESTAMP]	26	TRUE	FALSE	6
INTERVAL YEAR	101 [UNKNOWN]	50	TRUE	FALSE	0
INTERVAL MONTH	102 [UNKNOWN]	50	TRUE	FALSE	0
INTERVAL DAY	103 [UNKNOWN]	50	TRUE	FALSE	0
INTERVAL HOUR	104 [UNKNOWN]	50	TRUE	FALSE	0
INTERVAL MINUTE	105 [UNKNOWN]	50	TRUE	FALSE	0
INTERVAL SECOND	106 [UNKNOWN]	50	TRUE	FALSE	0
INTERVAL YEAR TO MONTH	107 [UNKNOWN]	50	TRUE	FALSE	0
INTERVAL DAY TO HOUR	108 [UNKNOWN]	50	TRUE	FALSE	0
INTERVAL DAY TO MINUTE	109 [UNKNOWN]	50	TRUE	FALSE	0
INTERVAL DAY TO SECOND	110 [UNKNOWN]	50	TRUE	FALSE	0
INTERVAL HOUR TO MINUTE	111 [UNKNOWN]	50	TRUE	FALSE	0
INTERVAL HOUR TO SECOND	112 [UNKNOWN]	50	TRUE	FALSE	0
INTERVAL MINUTE TO SECOND	113 [UNKNOWN]	50	TRUE	FALSE	0
TIMETZ	1266 [UNKNOWN]	21	TRUE	FALSE	6