Date format syntax in CYPHER

[sojan_mathew]

Hi All,

I have an epoch date with microsencods (1549641709667000).I want to convert that into date without timezone .As of now i am doing this .

return datetime({epochMillis:1549641709667000/1000})

• "2019-02-08T10:01:49.667000000[America/Chicago]"

Is there another way to get this without dividing by 1000 ? Also i am not interested in the timezone .I just need "2019-02-08T10:01:49.667000000"

thanks for the help in advance.

Sojan

[ameyasoft]

Try this:

return  apoc.date.format(1549641709667000/1000, 'ms', 'yyyy-MM-dd HH:MM:SS:mmmmm')

Result: "2019-02-08 16:02:667:00001"

[sojan_mathew]

Thank you for your time