Attribute

FetchTWFSasTime (FTWFSAT)

Purpose

Determines which ODBC data type the driver uses to return column values with the BIGTIME data type.

Valid Values

0 | 1

Behavior

If set to 1, the driver returns column values for the BIGTIME data type as the ODBC data type SQL_TYPE_TIME. The fractional seconds portion of the value is truncated.

If set to 0, the driver returns column values for the BIGTIME data type as the ODBC data type SQL_TYPE_TIMESTAMP. When a timestamp is returned for BIGTIME, the Year, Month and Day parts of the timestamp must be set to zero.

Notes

• The BIGTIME data type is supported in Sybase 15.5 and higher.

Default

1

GUI Tab

Advanced tab