﻿---
title: Datetime difference (elapsed time)
description: Use either two numeric datetimes or two complex datetimes to calculate the difference (elapsed time) between two different datetimes. Use subtraction...
url: https://www.elastic.co/elastic/docs-builder/docs/3028/reference/scripting-languages/painless/painless-datetime-difference
products:
  - Elasticsearch
  - Painless
applies_to:
  - Elastic Cloud Serverless: Generally available
  - Elastic Stack: Generally available
---

# Datetime difference (elapsed time)
Use either two numeric datetimes or two complex datetimes to calculate the difference (elapsed time) between two different datetimes. Use [subtraction](/elastic/docs-builder/docs/3028/reference/scripting-languages/painless/painless-operators-numeric#subtraction-operator) to calculate the difference between two numeric datetimes of the same time unit such as milliseconds. For complex datetimes there is often a method or another complex type ([object](/elastic/docs-builder/docs/3028/reference/scripting-languages/painless/painless-types#reference-types)) available to calculate the difference. Use [ChronoUnit](https://www.elastic.co/guide/en/elasticsearch/painless/current/painless-api-reference-shared-java-time-temporal.html#painless-api-reference-shared-ChronoUnit) to calculate the difference between two complex datetimes if supported.

## Datetime difference examples

- Calculate the difference in milliseconds between two numeric datetimes:
  ```java
  long startTimestamp = 434931327000L;
  long endTimestamp = 434931330000L;
  long differenceInMillis = endTimestamp - startTimestamp;
  ```
- Calculate the difference in milliseconds between two complex datetimes:
  ```java
  ZonedDateTime zdt1 =
          ZonedDateTime.of(1983, 10, 13, 22, 15, 30, 11000000, ZoneId.of('Z'));
  ZonedDateTime zdt2 =
          ZonedDateTime.of(1983, 10, 13, 22, 15, 35, 0, ZoneId.of('Z'));
  long differenceInMillis = ChronoUnit.MILLIS.between(zdt1, zdt2);
  ```
- Calculate the difference in days between two complex datetimes:
  ```java
  ZonedDateTime zdt1 =
          ZonedDateTime.of(1983, 10, 13, 22, 15, 30, 11000000, ZoneId.of('Z'));
  ZonedDateTime zdt2 =
          ZonedDateTime.of(1983, 10, 17, 22, 15, 35, 0, ZoneId.of('Z'));
  long differenceInDays = ChronoUnit.DAYS.between(zdt1, zdt2);
  ```