# Date format conversion

**URL:** <https://community.neo4j.com/t/date-format-conversion/42739>\
**Category:** Neo4j Graph Platform\
**Created:** [August 11, 2021, 8:07am UTC](https://community.neo4j.com/t/date-format-conversion/42739 "2021-08-11T08:07:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ganeshbdas1](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ganeshbdas1/32/5414_2.png) [@ganeshbdas1](https://community.neo4j.com/u/ganeshbdas1)\
**Post date:** [August 11, 2021, 8:07am UTC](https://community.neo4j.com/t/date-format-conversion/42739/1 "2021-08-11T08:07:03Z")

</div>

How to convert the date from YYYY-MM-dd HH:mm:ss format to this YYYY-MM-dd'T'HH:mm:ssz format from neo4j .

---

<div class="post-metadata">

**Author:** ![Benoit\_d](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/benoit_d/32/3833_2.png) [@Benoit\_d](https://community.neo4j.com/u/Benoit_d)\
**Post date:** [August 11, 2021, 9:15am UTC](https://community.neo4j.com/t/date-format-conversion/42739/2 "2021-08-11T09:15:20Z")

</div>

> **[apoc.date.convertFormat - APOC Extended Documentation](https://neo4j.com/labs/apoc/4.3/overview/apoc.date/apoc.date.convertFormat/)**
>
> This section contains reference documentation for the apoc.date.convertFormat function.

Therefore it should be something like:  
apoc.date.convertFormat("2021-08-11 11:10:00", "YYYY-MM-dd HH:mm:ss", date\_hour\_minute\_second\_fraction)  
or  
apoc.date.convertFormat("2021-08-11 11:10:00", "YYYY-MM-dd HH:mm:ss", "YYYY-MM-dd'T'HH:mm:ssS")

---

<div class="post-metadata">

**Author:** ![ameyasoft](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ameyasoft/32/32639_2.png) [@ameyasoft](https://community.neo4j.com/u/ameyasoft)\
**Post date:** [August 12, 2021, 6:20am UTC](https://community.neo4j.com/t/date-format-conversion/42739/3 "2021-08-12T06:20:48Z")

</div>

```auto
Try this:

RETURN apoc.date.format(apoc.date.parse("2016-01-01 15:54:11", 's',"yyyy-MM-dd HH:mm:ss"), 's', "yyyy-MM-dd'T'HH:mm:ssz") as val
 
Result: "2016-01-01T15:54:11UTC"

```

---

<div class="post-metadata">

**Author:** ![ganeshbdas1](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ganeshbdas1/32/5414_2.png) [@ganeshbdas1](https://community.neo4j.com/u/ganeshbdas1)\
**Post date:** [August 23, 2021, 7:18am UTC](https://community.neo4j.com/t/date-format-conversion/42739/4 "2021-08-23T07:18:22Z")

</div>

> [@ameyasoft](#):
>
> ```auto
> RETURN apoc.date.format(apoc.date.parse("2016-01-01 15:54:11", 's',"yyyy-MM-dd HH:mm:ss"), 's', "yyyy-MM-dd'T'HH:mm:ssz") as val
>  
> Result: "2016-01-01T15:54:11UTC"
> 
> ```

Is it possible to change only the type without changing the format?

Currently save in "2016-01-01 15:54:11" format as a string {Datatype} , Expectation is 2016-01-01 15:54:11 as date {Datatype} .