MilliSecondsBetween

Description

Returns the number of milliseconds between the end_datetime and the start_datetime.

Syntax

MilliSecondsBetween(end_datetime, start_datetime)

Arguments

  end_datetime - datetime expression.

  start_datetime - datetime expression.

Examples

MilliSecondsBetween(ToDate('2013-09-10T08:02:31.667Z'),ToDate('2012-03-03T13:34:39.648Z')) returns 48018472019

Return value datatype

Long

Impact of null value

If input is null, returns null.