---
title: ES|QL date-time functions
description: ES|QL supports these date-time functions: 
url: https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/functions-operators/date-time-functions
products:
  - Elasticsearch
applies_to:
  - Elastic Cloud Serverless: Generally available
  - Elastic Stack: Generally available
---

# ES|QL date-time functions
ES|QL supports these date-time functions:
- [`DATE_DIFF`](https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/functions-operators/date-time-functions/date_diff)
- [`DATE_EXTRACT`](https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/functions-operators/date-time-functions/date_extract)
- [`DATE_FORMAT`](https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/functions-operators/date-time-functions/date_format)
- [`DATE_PARSE`](https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/functions-operators/date-time-functions/date_parse)
- [`DATE_TRUNC`](https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/functions-operators/date-time-functions/date_trunc)
- [`DAY_NAME`](https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/functions-operators/date-time-functions/day_name) <applies-to>Elastic Stack: Generally available since 9.2</applies-to>
- [`MONTH_NAME`](https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/functions-operators/date-time-functions/month_name) <applies-to>Elastic Stack: Generally available since 9.2</applies-to>
- [`NOW`](https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/functions-operators/date-time-functions/now)
- [`TRANGE`](https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/functions-operators/date-time-functions/trange) <applies-to>Elastic Stack: Generally available since 9.3</applies-to>