Specifies whether to retrieve TIME values with fractional seconds as TIME values.
| Valid in: | LIBNAME statement that connects to an external data source |
|---|---|
| Category: | Data Set Control |
| Default: | YES |
| Data source: | Greenplum |
| Note: | Support for this option was added in SAS 9.4M9. |
Table of Contents
specifies that SAS/ACCESS loads TIME values with fractional seconds as TIME values in SAS.
specifies that SAS/ACCESS loads TIME values with fractional seconds as TIMESTAMP values in SAS.
When SAS/ACCESS reads TIME values with fractional seconds into SAS, the values are loaded into SAS as NUMERIC values. The format that is applied varies based on this setting. When FETCH_TWFS_AS_TIME=YES, these values are formatted in SAS as TIME8. values. If FETCH_TWFS_AS_TIME=NO, then TIME values with fractional seconds are formatted in SAS as DATETIME25.6 values.