Module sql_types Copy item path Source DatetimeIntervalCode SqlTypeV3 SqlTypeV4 SqlTypeV3_8 SQL_ARRAY SQL_BIGINT Exact numeric value with precision 19 (if signed) or 20 (if unsigned) and scale 0 (signed: -2[63] <= n <= 2[63] - 1, unsigned: 0 <= n <= 2[64] - 1),. SQL_BINARY Binary data of fixed length n. SQL_BIT Single bit binary data. SQL_CHAR Character string of fixed string length n. SQL_CODE_DATE SQL_CODE_DAY SQL_CODE_DAY_TO_HOUR SQL_CODE_DAY_TO_MINUTE SQL_CODE_DAY_TO_SECOND SQL_CODE_HOUR SQL_CODE_HOUR_TO_MINUTE SQL_CODE_HOUR_TO_SECOND SQL_CODE_MINUTE SQL_CODE_MINUTE_TO_SECOND SQL_CODE_MONTH SQL_CODE_SECOND SQL_CODE_TIME SQL_CODE_TIMESTAMP SQL_CODE_YEAR SQL_CODE_YEAR_TO_MONTH SQL_DATETIME Datetime verbose type identifier. SQL_DECIMAL Signed, exact, numeric value with a precision of at least p and scale s. (The maximum precision is driver-defined.) (1 <= p <= 15; s <= p). SQL_DOUBLE Signed, approximate, numeric value with a binary precision 53 (zero or absolute value 10[-308] to 10[308]). SQL_FLOAT Signed, approximate, numeric value with a binary precision of at least p. (The maximum precision is driver-defined.) SQL_GUID Fixed length GUID. SQL_INTEGER Exact numeric value with precision 10 and scale 0 (signed: -2[31] <= n <= 2[31] - 1, unsigned: 0 <= n <= 2[32] - 1). SQL_INTERVAL Interval verbose type identifier. SQL_INTERVAL_DAY Number of days between two dates; p is the interval leading precision. SQL_INTERVAL_DAY_TO_HOUR Number of days/hours between two date/times; p is the interval leading precision. SQL_INTERVAL_DAY_TO_MINUTE Number of days/hours/minutes between two date/times; p is the interval leading precision. SQL_INTERVAL_DAY_TO_SECOND Number of days/hours/minutes/seconds between two date/times; p is the interval leading precision and q is the interval seconds precision. SQL_INTERVAL_HOUR Number of hours between two date/times; p is the interval leading precision. SQL_INTERVAL_HOUR_TO_MINUTE Number of hours/minutes between two date/times; p is the interval leading precision. SQL_INTERVAL_HOUR_TO_SECOND Number of hours/minutes/seconds between two date/times; p is the interval leading precision and q is the interval seconds precision. SQL_INTERVAL_MINUTE Number of minutes between two date/times; p is the interval leading precision. SQL_INTERVAL_MINUTE_TO_SECOND Number of minutes/seconds between two date/times; p is the interval leading precision and q is the interval seconds precision. SQL_INTERVAL_MONTH Number of months between two dates; p is the interval leading precision. SQL_INTERVAL_SECOND Number of seconds between two date/times; p is the interval leading precision and q is the interval seconds precision. SQL_INTERVAL_YEAR Number of years between two dates; p is the interval leading precision. SQL_INTERVAL_YEAR_TO_MONTH Number of years and months between two dates; p is the interval leading precision. SQL_LONGVARBINARY Variable length binary data. Maximum length is data source-dependent. SQL_LONGVARCHAR Variable length character data. Maximum length is data source-dependent. SQL_MULTISET SQL_NUMERIC Signed, exact, numeric value with a precision p and scale s (1 <= p <= 15; s <= p). SQL_REAL Signed, approximate, numeric value with a binary precision 24 (zero or absolute value 10[-38] to 10[38]). SQL_ROW SQL_SMALLINT Exact numeric value with precision 5 and scale 0 (signed: -32,768 <= n <= 32,767, unsigned: 0 <= n <= 65,535). SQL_TINYINT Exact numeric value with precision 3 and scale 0 (signed: -128 <= n <= 127, unsigned: 0 <= n <= 255). SQL_TYPE_DATE Year, month, and day fields, conforming to the rules of the Gregorian calendar. (See Constraints of the Gregorian Calendar, later in this appendix.) SQL_TYPE_TIME Hour, minute, and second fields, with valid values for hours of 00 to 23, valid values for minutes of 00 to 59, and valid values for seconds of 00 to 61. Precision p indicates the seconds precision. SQL_TYPE_TIMESTAMP Year, month, day, hour, minute, and second fields, with valid values as defined for the DATE and TIME data types. SQL_TYPE_TIMESTAMP_WITH_TIMEZONE SQL_TYPE_TIME_WITH_TIMEZONE SQL_UDT SQL_UNKNOWN_TYPE Data type cannot be determined SQL_VARBINARY Variable length binary data of maximum length n. The maximum is set by the user. SQL_VARCHAR Variable-length character string with a maximum string length n. SQL_VARIANT_TYPE Column whose type may vary across rows SQL_WCHAR Unicode character string of fixed string length n SQL_WLONGVARCHAR Unicode variable-length character data. Maximum length is data source-dependent SQL_WVARCHAR Unicode variable-length character string with a maximum string length n SqlType