Constants - Data Types¶
Constants returnable by ParameterType and ParameterInfo
| Type | Description | Data Example |
|---|---|---|
SQL_BIGINT |
Stores a 64 bit integer. That is a double integer. | 123456789 |
SQL_BINARY |
Binary string. Variable length | binary data |
SQL_CHAR |
Character string of fixed string length | test |
SQL_DATETIME |
Stores year, month, day, hour, minute, and second values | |
SQL_DOUBLE |
Signed, approximate, numeric value with a binary precision 53 | 12.123456 |
SQL_INTEGER |
Exact numeric value with precision 10 and scale 0 | 4 |
SQL_NUMERIC |
Exact numerical | 2.12 |
SQL_TYPE_DATE |
Stores year, month, and day values | {d '2011-01-16'} |
SQL_TYPE_TIME |
Stores hour, minute, and second values | {t '09:49:10'} |
SQL_TYPE_TIMESTAMP |
Stores year, month, day, hour, minute, and second values | {ts '2011-01-16 09:49:10'} |
SQL_UNKNOWN_TYPE |