Home : Time Range Literal List for Math Toolbox
Q10946 - INFO: Time Range Literal List for Math Toolbox

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

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 4/17/2008 3:33 PM.
Last Modified on 4/17/2008 3:33 PM.
Last Modified by No Author Name Available!.
Article has been viewed 4251 times.
Rated 9 out of 10 based on 2 votes.
Print Article
Email Article