Time Range Literal is an optional input for Advanced Math Toolbox Functions and defines start and end dates for a time interval:
MONTHLY, CURRENTMONTH |
From the first day to last day of the current month being calculated |
WEEKLYx |
From the first day to last day of the week being calcualted according to the week defined by x. |
DAILY, CURRENTDAY |
The current day being calculated |
QUARTERLY |
The current quarter |
YEARLY, CURRENYEAR |
The current year being calculated |
CURRENTHOUR |
The current hour being calculated |
CURRENTQTRHOUR |
The current Quarter Hour being calculated |
|
|
CURRENT4HOUR |
The current 4 hour period being calculated, only available in OPS SQL |
CURRENT5MINUTE |
The current 5 minute period being calculated, only availabe in OPS SQL |
CURRENTHALFHOUR |
The current half hour being calculated, only available in OPS SQL |
|