Time Functions
Provides deterministic, time-centric utility functions for AiSQL. Functions operate on explicit time values or on the AiSQL evaluation-time context. Note: Use of time-based functions introduces temporal variability into evaluation and should be considered when deterministic repeatability across evaluations is required.
| Name | Parameters | Returns | Description |
| Time.AddDays | (decimal days) | DateTime | Adds days to the current time. |
| Time.AddDaysFrom | (DateTime value, decimal days) | DateTime | Adds the specified number of days to a DateTime. |
| Time.AddHours | (decimal hours) | DateTime | Adds hours to the current time. |
| Time.AddHoursFrom | (DateTime value, decimal hours) | DateTime | Adds the specified number of hours to a DateTime. |
| Time.AddMilliseconds | (decimal milliseconds) | DateTime | Adds milliseconds to the current time. |
| Time.AddMillisecondsFrom | (DateTime value, decimal milliseconds) | DateTime | Adds the specified number of milliseconds to a DateTime. |
| Time.AddMinutes | (decimal minutes) | DateTime | Adds minutes to the current time. |
| Time.AddMinutesFrom | (DateTime value, decimal minutes) | DateTime | Adds the specified number of minutes to a DateTime. |
| Time.AddSeconds | (decimal seconds) | DateTime | Adds seconds to the current time. |
| Time.AddSecondsFrom | (DateTime value, decimal seconds) | DateTime | Adds the specified number of seconds to a DateTime. |
| Time.AddYears | (int Years) | DateTime | Adds the specified number of Years from a DateTime. |
| Time.AddYearsFrom | (DateTime value, int Years) | DateTime | Adds the specified number of Years from a DateTime. |
| Time.DayOfWeek | () | int | Returns the current day of week as an integer (0 = Sunday). |
| Time.Hour | () | int | Returns the current hour (0–23). |
| Time.HoursSince | (DateTime value) | double | Returns the number of hours elapsed since the given DateTime. |
| Time.IsAfter | (DateTime value) | bool | Returns true if the current time is after the specified DateTime. |
| Time.IsBefore | (DateTime value) | bool | Returns true if the current time is before the specified DateTime. |
| Time.Minute | () | int | Returns the current minute (0–59). |
| Time.MinutesSince | (DateTime value) | double | Returns the number of minutes elapsed since the given DateTime. |
| Time.Now | () | DateTime | Returns the current local date and time with full precision. |
| Time.NowHours | () | DateTime | Returns the current local time truncated to hours. |
| Time.NowMinutes | () | DateTime | Returns the current local time truncated to minutes. |
| Time.NowSeconds | () | DateTime | Returns the current local time truncated to seconds. |
| Time.Second | () | int | Returns the current second (0–59). |
| Time.SecondsSince | (DateTime value) | double | Returns the number of seconds elapsed since the given DateTime. |
| Time.SubtractDays | (decimal days) | DateTime | Subtracts days from the current time. |
| Time.SubtractDaysFrom | (DateTime value, decimal days) | DateTime | Subtracts the specified number of days from a DateTime. |
| Time.SubtractHours | (decimal hours) | DateTime | Subtracts hours from the current time. |
| Time.SubtractHoursFrom | (DateTime value, decimal hours) | DateTime | Subtracts the specified number of hours from a DateTime. |
| Time.SubtractMilliseconds | (decimal milliseconds) | DateTime | Subtracts milliseconds from the current time. |
| Time.SubtractMillisecondsFrom | (DateTime value, decimal milliseconds) | DateTime | Subtracts the specified number of milliseconds from a DateTime. |
| Time.SubtractMinutes | (decimal minutes) | DateTime | Subtracts minutes from the current time. |
| Time.SubtractMinutesFrom | (DateTime value, decimal minutes) | DateTime | Subtracts the specified number of minutes from a DateTime. |
| Time.SubtractSeconds | (decimal seconds) | DateTime | Subtracts seconds from the current time. |
| Time.SubtractSecondsFrom | (DateTime value, decimal seconds) | DateTime | Subtracts the specified number of seconds from a DateTime. |
| Time.SubtractYears | (int Years) | DateTime | Subtracts the specified number of Years from a DateTime. |
| Time.SubtractYearsFrom | (DateTime value, int Years) | DateTime | Subtracts the specified number of Years from a DateTime. |
| Time.Today | () | DateTime | Returns today's date with time set to 00:00:00. |
| Time.UtcNow | () | DateTime | Returns the current UTC date and time with full precision. |
Examples
RULE TradeLatency
IF
TIME_DIFF_SECONDS(OrderTime, FillTime) > 2.5
AND
TIME_HOUR(FillTime) >= 9
THEN
ACTION = 'ReduceOrderRate'