# How to read date time value not separated by T?

**URL:** <https://community.neo4j.com/t/how-to-read-date-time-value-not-separated-by-t/4172>\
**Category:** Cypher\
**Tags:** apoc\
**Created:** [January 4, 2019, 10:55am UTC](https://community.neo4j.com/t/how-to-read-date-time-value-not-separated-by-t/4172 "2019-01-04T10:55:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gauravjbjain](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/gauravjbjain/32/541_2.png) [@gauravjbjain](https://community.neo4j.com/u/gauravjbjain)\
**Post date:** [January 4, 2019, 10:55am UTC](https://community.neo4j.com/t/how-to-read-date-time-value-not-separated-by-t/4172/1 "2019-01-04T10:55:37Z")

</div>

Hi All,

I am trying to load the CSV data into Neo4J and my CSV contains datetime variable having values in the format of 15-12-2018 10:00:30 .

If I add T in between like 15-12-2018T10:00:30 then I am able to parse as Datetime in Neo4J not without adding T.

Can anyone help me how can I parse string "15-12-2018 10:00:30" as DateTime while loading this in Neo4J.

Regards  
Gaurav

---

<div class="post-metadata">

**Author:** ![david\_allen](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/david_allen/32/13090_2.png) [@david\_allen](https://community.neo4j.com/u/david_allen)\
**Post date:** [January 4, 2019, 9:45pm UTC](https://community.neo4j.com/t/how-to-read-date-time-value-not-separated-by-t/4172/2 "2019-01-04T21:45:51Z")

</div>

Whether or not you have a T in the input, you should be able to use `apoc.date.parse` to get the job done with the right format string.

Here's the documentation:

[https://neo4j-contrib.github.io/neo4j-apoc-procedures/#\_conversion\_functions\_between\_formatted\_dates\_and\_timestamps](https://neo4j-contrib.github.io/neo4j-apoc-procedures/#_conversion_functions_between_formatted_dates_and_timestamps)

(This requires that you download and install the APOC plugin into your database)

---

<div class="post-metadata">

**Author:** ![gauravjbjain](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/gauravjbjain/32/541_2.png) [@gauravjbjain](https://community.neo4j.com/u/gauravjbjain)\
**Post date:** [January 5, 2019, 7:06am UTC](https://community.neo4j.com/t/how-to-read-date-time-value-not-separated-by-t/4172/3 "2019-01-05T07:06:50Z")

</div>

Thanks David, I realized my mistake.

It's working now and I am able to use apoc.date.format on top of that as well.