Berserk Docs
Scalar FunctionsDate & Time Functions

datetime_diff

Returns the difference between two datetime values.

Syntax

datetime_diff(part, date1, date2)

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: long

Examples

Example 1

print datetime_diff("day", datetime(2024-11-01), datetime(2024-06-08)) // days between Lindisfarne and the Great Heathen Army
print_0 (long)
146

Example 2

print datetime_diff("year", datetime(2024-09-25), datetime(2024-06-08)) // years of the Viking Age
print_0 (long)
0

On this page