...
| Type | Description |
|---|---|
| Current | The current date and time as of executing the SQL. |
| TopHour | The current top of hour as of executing the SQL. Example: Current Time=12.:30PM, TopHour=12.:00PM |
| StartDay | The current date as of executing the SQL. |
| EndDay | The current date plus 1 day as of executing the SQL. |
| Yesterday | The current date minus 1 day as of executing the SQL. |
| PriorHour | The last top hour minus 1 hour from current date and time as of executing the SQL. Example: Current Time=12.:30PM, PriorHour=11.:00AM |
| NextHour | The next top of hour plus 1 hour from current date and time as of executing the SQL. Example: Current Time=12.:30PM, NextHour=1.:00PM |
| StartMonth | The date of the first day of the current month as of executing the SQL. |
...