SECONDS_BETWEEN
Description
SECONDS_BETWEEN
is a row function that calculates the whole number of seconds (ignoring milliseconds) between two DATE
values (value1
- value2
).Syntax
SECONDS_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 seconds it took for a user to click on an advertisement by subtracting the value of the
impression_timestamp
field from the conversion_timestamp
field:SECONDS_BETWEEN([impression_timestamp], [conversion_timestamp])