Having problems with converting a timestamp to a date

Neo4j Graph Platform Cypher
1

when using this statement datetime(r.timestamp/1000)

I get this error

Invalid call signature for DateTimeFunction: Provided input was [Long(1298932)]

Can someone help me out?

2

In the graph, What is the type of the property timestamp? (CALL apoc.meta.relTypeProperties())

How is the value set for this property?

You might want to take a look at working with temporal data in the doc:

Elaine

3

Hi Elaine and thank you for replying.
The value was 1238932 and defined as a long

The error says "Invalid call signature for DateTimeFunction: Provided Input was [Long(1238932)]
So I know the Data Type is right but not sure what is causing the error.

I was just going through your Neo4J data aggregate course and my query kept getting stuck on this issue.

4

It looks like your property is a long. Does this represent an epoch time. Try this instead;

datetime({epochSeconds: r.timestamp / 1000})

1 Like
5

Thank you! That solved it!