> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: MilliSecondsBetween

> Calculate the number of milliseconds between two datetime values. Use MILLISECONDSBETWEEN for sub-second duration measurement in ETL data pipelines.

## 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.