Scalar FunctionsDate & Time Functions
datetime_add
Adds a specified amount to a datetime value.
Syntax
datetime_add(part, value, date)Parameters
Prop
Type
Given a dynamic field
This parameter is string-only. In permissive mode — the default — almost every field arrives as a dynamic, so passing one works because Berserk injects asstring: extract-or-null, the value when it really is a string and null otherwise, so the call yields null (a predicate yields false). A property bag or array is therefore not matched, and tostring() is never applied implicitly — use it explicitly to match a bag's JSON text, keys included. Strict mode rejects the dynamic instead of coercing it. See String coercion and the asXXX family.
Returns: datetime
Examples
Example 1
print datetime_add("day", 14, datetime(2024-06-08)) // two weeks after the Lindisfarne raid| print_0 (datetime) |
|---|
| 2024-06-22T00:00:00Z |
Example 2
print datetime_add("year", 73, datetime(2024-06-08)) // years until the Great Heathen Army| print_0 (datetime) |
|---|
| 2097-06-08T00:00:00Z |