Updated: 2023-09-12
Data Source Initialization OLE DB Property — «dbtimestamp_with_tz_rules»
Name:
dbtimestamp_with_tz_rules
Type:
VT_I4
R/W:
R/W
Default:
2
IBProvider:
5.31
Rules for columns or parameters with datatype TIMESTAMP WITH TIME ZONE. Can be one from the following values:
| Value | Description |
| 1 | The datatype DBTYPE_DBTIMESTAMPOFFSET is used |
| 2 | The datatype DBTYPE_WSTR with length 88 symbols (for FB4) is used |
By default provider processes TIMESTAMP WITH TIME ZONE as text. It saves the information about time zone region.
Using DBTYPE_DBTIMESTAMPOFFSET increases the speed of TIMESTAMP WITH TIME ZONE processing but the information about region will be lost.
See also
- Initialization property dbtime_with_tz_rules
- Initialization property dbtime_rules
- Initialization property dbdate_rules
- Initialization property dbtimestamp_rules
- Initialization property timezones_source