lets you provide a datetime range to use when querying or modifying a temporal table.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | none |
| Data source: | DB2 for z/OS |
| See: | TEMPORAL= data set option, OVERLAPS= data set option,BUSINESS_DATATYPE= data set option, BUSINESS_TIMEFRAME= data set option |
Table of Contents
specifies a datetime value that indicates the beginning or end of a time period that is used when you query or modify a table that contains temporal data.
Provide datetime values that include year, month, day, hours, minutes, seconds, and fractions of a second. For example, use the following code to specify the time period from midnight, November 1, 2012 to midnight, December 1, 2030:
system_timeframe="from '2012-11-01-00.00.00.0' to '2030-12-01-00.00.00.0'"