Part 4: The Connect XE Drivers : The Greenplum Wire Protocol Driver : Connection Option Descriptions : Fetch TWFS as Time

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
Default
0 (Disabled)
GUI Tab
Advanced tab

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.