MILLISECONDS_BETWEEN
Description
MILLISECONDS_BETWEEN
is a row function that calculates the whole number of milliseconds between two DATE
values (value1
- value2
).Syntax
MILLISECONDS_BETWEEN
(date_1
,date_2
)Return Value
Returns one value per row of the same type as the input.
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 milliseconds it took to serve a web page by subtracting the value of the
request_timestamp
field from the response_timestamp
field:MILLISECONDS_BETWEEN([request_timestamp], [response_timestamp])