date_diff

datetime

Calculates the difference between two dates

Syntax

date_diff(date1, date2, unit?)

Parameters

date1 (date|timestamp)

The first date (typically the later date)

date2 (date|timestamp)

The second date (typically the earlier date)

unit (string) optional

The unit for the result ("seconds", "minutes", "hours", "days", "weeks")

Returns

number

The difference in the specified unit (default is days)

Examples

Difference in days (default)

Input:

date_diff("2024-01-20", "2024-01-15")

Output:

Difference in hours

Input:

date_diff("2024-01-15 14:30:00", "2024-01-15 12:00:00", "hours")

Output:

2.5

Calculate time between fields

Input:

date_diff(.end_date, .start_date, "minutes")

Output:

Duration in minutes

Filter by date range

Input:

map(select(date_diff(today(), .date, "days") <= 7))

Output:

Filter records from last 7 days

The date_diff() function calculates the difference between two dates or timestamps. The default unit is days. Supported units are “seconds”, “minutes”, “hours”, “days”, and “weeks”.

Usage

Use date_diff() to calculate durations, age, elapsed time, filter records by time ranges, or compute time-based metrics.

Related Functions

today now year month day