# Problem with datetimes from python/pandas

**URL:** <https://community.neo4j.com/t/problem-with-datetimes-from-python-pandas/13959>\
**Category:** Cypher\
**Created:** [January 23, 2020, 1:59pm UTC](https://community.neo4j.com/t/problem-with-datetimes-from-python-pandas/13959 "2020-01-23T13:59:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![guinametal](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/guinametal/32/7961_2.png) [@guinametal](https://community.neo4j.com/u/guinametal)\
**Post date:** [January 23, 2020, 1:59pm UTC](https://community.neo4j.com/t/problem-with-datetimes-from-python-pandas/13959/1 "2020-01-23T13:59:41Z")

</div>

Dear colleagues,

I'm struggling with datetimes from python/pandas. I'm building a graph from pandas data in which nodes are meant to have da timestamp property imported from pandas. In the pandas dataframe I have a datetime[64] column that reads like '2018-02-20T22:06:55.001290' (iso format) and I can import datetime data as dtrings in nodes properties. The problem is that I'm not able to parse the datetime strings in a way they can be used to match nodes according to a time interval, for example.

What is the best approach when importing datetime data from pandas to neo4j ?

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![ganesanmithun323](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ganesanmithun323/32/5414_2.png) [@ganesanmithun323](https://community.neo4j.com/u/ganesanmithun323)\
**Post date:** [January 23, 2020, 5:18pm UTC](https://community.neo4j.com/t/problem-with-datetimes-from-python-pandas/13959/2 "2020-01-23T17:18:12Z")

</div>

you can use DATETIME("2018-02-20T22:06:55.001290") if you are using cypher to ingest data to graph .  
if you already have the dates as strings in graph, you can convert them using DATETIME(node.stringDateProperty) and store as node.dateProperty ..then use dateProperty to query based on time intervals