---
title: ES|QL DAY_NAME function
description: 
url: https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/functions-operators/date-time-functions/day_name
products:
  - Elasticsearch
---

# ES|QL DAY_NAME function
<applies-to>
  - Elastic Stack: Generally available since 9.2
</applies-to>


## Syntax

![Embedded](https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/images/functions/day_name.svg)


## Parameters

<definitions>
  <definition term="date">
    Date expression. If `null`, the function returns `null`.
  </definition>
</definitions>


## Description

Returns the name of the weekday for date based on the configured Locale.

## Supported types


| date       | result  |
|------------|---------|
| date       | keyword |
| date_nanos | keyword |


## Example

```esql
ROW dt = to_datetime("1953-09-02T00:00:00.000Z")
| EVAL weekday = DAY_NAME(dt);
```