Fetch TWFS as Time
- Last Updated: February 8, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- PostgreSQL 8.0
- Documentation
Fetch TWFS as Time
Attribute
FetchTWFSasTime (FTWFSAT)
Purpose
Determines whether the driver returns column values with the time data type as the ODBC data type SQL_TYPE_TIME or SQL_TYPE_TIMESTAMP.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), the driver returns column values
with the time data type as the ODBC data type SQL_TYPE_TIME. The fractional seconds portion
of the value is truncated.
If set to 0 (Disabled), the driver returns column values
with the time data type as the ODBC data type SQL_TYPE_TIMESTAMP. The fractional seconds
portion of the value is preserved. Time columns are not searchable when they are described
and fetched as timestamp.
Notes
- When returning time with fractional seconds data as SQL_TYPE_TIMESTAMP, the date portion of the timestamp is set to the current date.
Default
0 (Disabled)