# Extract date from timestamp field
**URL:** https://discuss.elastic.co/t/extract-date-from-timestamp-field/259349
**Category:** Kibana
**Tags:** elastic-stack-sql
**Created:** [December 22, 2020, 8:45am UTC](https://discuss.elastic.co/t/extract-date-from-timestamp-field/259349 "2020-12-22T08:45:35Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@anjali28](https://discuss.elastic.co/u/anjali28)
#### Post date: [December 22, 2020, 8:45am UTC](https://discuss.elastic.co/t/extract-date-from-timestamp-field/259349/1 "2020-12-22T08:45:35Z")
hello,
i have a time field and i want to extract date from it in my elasticsearch sql query.
Below is the format of time: 2020-01-11T02:13:00.000Z
which function in elasticsearch sql query will extract the date from it.
I am using date\_part function but its not return the date
"DATE\_PART('date', time) AS logindate"
Please help.
---
### Author:  [@AClerk](https://discuss.elastic.co/u/AClerk)
#### Post date: [December 23, 2020, 12:40am UTC](https://discuss.elastic.co/t/extract-date-from-timestamp-field/259349/2 "2020-12-23T00:40:03Z")
> [@anjali28](#):
>
> 2020-01-11T02:13:00.000Z
```auto
POST /_sql?format=csv
{
"query": "SELECT DATETIME_FORMAT(CAST('2020-01-11T02:13:00.000Z' AS DATE), 'dd/MM/YYYY') as mydate"
}
```
RESULT --\>
```auto
mydate
11/01/2020
```
> **[Date/Time and Interval Functions and Operators | Elasticsearch Guide \[8.11\] |...](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-datetime.html#sql-functions-datetime-datetimeformat)**
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 20, 2021, 12:40am UTC](https://discuss.elastic.co/t/extract-date-from-timestamp-field/259349/3 "2021-01-20T00:40:10Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.