MINUTES_BETWEEN
Description
MINUTES_BETWEEN
is a row function that calculates the whole number of
minutes (ignoring seconds and milliseconds) between two date
values
(value1
- value2
).Syntax
MINUTES_BETWEEN
(date_1
,date_2
)Return Value
Returns one value per row of type
Integer
.Input Parameters
- date_1
- Required. A field or expression of typeDate.
- date_2
- Required. A field or expression of typeDate.
Examples
Calculate the number of minutes it took for a user to click on an advertisement by
subtracting the value of the
impression_timestamp
field from the
conversion_timestamp
field:MINUTES_BETWEEN([impression_timestamp],[conversion_timestamp])