DateTime Format


(Ashwin Dinesh01) #1

How can I save and retrieve DateTime along with timezone in neo4j while creating a new node?

CREATE (n:Person {name: "John", age: 24, dob: datetime("what should be the format here")});

I am sending the format "2018-12-26T22:10:15.120+05:30" from the client.

Also how to retrieve this DateTime object as a string in any format?


(Matthew Browning) #2

You should be able to do something like this:

CREATE(n:Person {name:"John", age: 24, dob: datetime("2018-12-26T22:10:15.120+05:30")})

That'll create a datetime object in neo4j. To access the values you should be able to something like this:

MATCH(n:Person) WITH n.dob as date RETURN date.year, date.month, date.day, date.hour, date.second

Depending on your usage, in my case the Go driver that I'm using returns it as a time language in Go, the case might be similar for you. If not there is an apoc function.

MATCH(n:Person) WITH n.dob as date RETURN apoc.date.format(date.epochSeconds, 's', 'MMM d yyyy') AS dateOfBirth

(Ashwin Dinesh01) #3

Thank you so much, that worked for me.