إشعار
يتطلب الوصول إلى هذه الصفحة تخويلاً. يمكنك محاولة تسجيل الدخول أو تغيير الدلائل.
يتطلب الوصول إلى هذه الصفحة تخويلاً. يمكنك محاولة تغيير الدلائل.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
This topic describes the column metadata returned by SQLColumns and SQLProcedureColumns, and the data type metadata returned by SQLGetTypeInfo.
Remarks
The following column values are returned for date/time types by SQLColumns and SQLProcedureColumns.
| Parameter Type | date | time | smalldatetime | datetime | datetime2 | datetimeoffset |
|---|---|---|---|---|---|---|
| DATA_TYPE | SQL_TYPE_DATE | SQL_SS_TIME2 | SQL_TYPE_TIMESTAMP | SQL_TYPE_TIMESTAMP | SQL_TYPE_TIMESTAMP | SQL_SS_TIMESTAMPOFFSET |
| TYPE_NAME | date | time | smalldatetime | datetime | datetime2 | datetimeoffset |
| COLUMN_SIZE | 10 | 8,10..16 | 16 | 23 | 19, 21..27 | 26, 28..34 |
| BUFFER_LENGTH | 6 | 10 | 16 | 16 | 16 | 20 |
| DECIMAL_DIGITS | 0 | 0..7 | 0 | 3 | 1..7 | 1..7 |
| SQL_DATA_TYPE | SQL_DATETIME | SQL_SS_TYPE_TIME2 | SQL_DATETIME | SQL_DATETIME | SQL_DATETIME | SQL_SS_TYPE_TIMESTAMPOFFSET |
| SQL_DATETIME_SUB | SQL_CODE_DATE | NULL | SQL_CODE_TIMESTAMP | SQL_CODE_TIMESTAMP | SQL_CODE_TIMESTAMP | NULL |
| CHAR_OCTET_LENGTH | NULL | NULL | NULL | NULL | NULL | NULL |
| SS_DATA_TYPE | 0 | 0 | 111 | 111 | 0 | 0 |
The following column values are returned for date/time types by SQLGetTypeInfo:
| Parameter Type | date | time | smalldatetime | datetime | datetime2 | datetimeoffset |
|---|---|---|---|---|---|---|
| TYPE_NAME | date | time | smalldatetime | datetime | datetime2 | datetimeoffset |
| DATA_TYPE | SQL_TYPE_DATE | SQL_SS_TIME2 | SQL_TYPE_TIMESTAMP | SQL_TYPE_TIMESTAMP | SQL_TYPE_TIMESTAMP | SQL_SS_TIMESTAMPOFFSET |
| COLUMN_SIZE | 10 | 16 | 16 | 23 | 27 | 34 |
| LITERAL_PREFIX | ' | ' | ' | ' | ' | ' |
| LITERAL_SUFFIX | ' | ' | ' | ' | ' | ' |
| CREATE_PARAMS | NULL | scale | NULL | NULL | scale | scale |
| NULLABLE | SQL_NULLABLE | SQL_NULLABLE | SQL_NULLABLE | SQL_NULLABLE | SQL_NULLABLE | SQL_NULLABLE |
| CASE_SENSITIVE | SQL_FALSE | SQL_FALSE | SQL_FALSE | SQL_FALSE | SQL_FALSE | SQL_FALSE |
| SEARCHABLE | SQL_PRED_SEARCHABLE | SQL_PRED_SEARCHABLE | SQL_PRED_SEARCHABLE | SQL_PRED_SEARCHABLE | SQL_PRED_SEARCHABLE | SQL_PRED_SEARCHABLE |
| UNSIGNED_ATTRIBUTE | NULL | NULL | NULL | NULL | NULL | NULL |
| FXED_PREC_SCALE | SQL_FALSE | SQL_FALSE | SQL_FALSE | SQL_FALSE | SQL_FALSE | SQL_FALSE |
| AUTO_UNIQUE_VALUE | NULL | NULL | NULL | NULL | NULL | NULL |
| LOCAL_TYPE_NAME | date | time | smalldatetime | datetime | datetime2 | datetimeoffset |
| MINIMUM_SCALE | 0 | 0 | 0 | 3 | 0 | 0 |
| MAXIMUM_SCALE | 0 | 7 | 0 | 3 | 7 | 7 |
| SQL_DATA_TYPE | SQL_DATETIME | SQL_SS_TIME2 | SQL_DATETIME | SQL_DATETIME | SQL_DATETIME | SQL_SS_TYPE_TIMESTAMPOFFSET |
| SQL_DATETIME_SUB | SQL_CODE_DATE | NULL | SQL_CODE_TIMESTAMP | SQL_CODE_TIMESTAMP | SQL_CODE_TIMESTAMP | NULL |
| NUM_PREC_RADIX | NULL | NULL | NULL | NULL | NULL | NULL |
| INTERVAL_PRECISION | NULL | NULL | NULL | NULL | NULL | NULL |
| USERTYPE | 0 | 0 | 12 | 22 | 0 | 0 |