Data Types for HDMD

The following table lists the data type support for HDMD.

The BINARY, DECIMAL/NUMERIC, FLOAT, NCHAR, and NVARCHAR data types are not supported for data type definition.

Data Types for HDMD
Data Type Definition Keyword	HDMD Data Type	Description	Data Type Returned
BIGINT	BIGINT	A large signed, exact whole number, with a precision of 19 digits. The range of integers is -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.	BIGINT
CHAR(n)	CHAR(n)	A fixed-length character string.	CHAR(n)
DATE	DATE	Date value.	DATE
DOUBLE	DOUBLE	A signed, approximate, double-precision, floating-point number. Note: Supports SAS missing values	DOUBLE
INTEGER	INTEGER	A regular size signed, exact whole number, with a precision of 10 digits. The range of integers is -2,147,483,648 to 2,147,483,647.	INTEGER
REAL	REAL	A signed, approximate, single-precision, floating-point number. Note: Supports SAS missing values	REAL
SMALLINT	SMALLINT	A small signed, exact whole number, with a precision of five digits. The range of integers is -32,768 to 32,767.	INTEGER
TIME(p)	TIME[p)]	Time value with optional precision.	TIME[(p)]
TIMESTAMP(p)	TIMESTAMP[p)]	Date and time value with optional precision.	TIMESTAMP[(p)]
TINYINT	TINYINT	A very small signed, exact whole number, with a precision of three digits. The range of integers is -128 to 127.	INTEGER
VARCHAR(n)	VARCHAR(n)	Varying-length character string data.	VARCHAR(n)