Impossible to compare dates in Open Cypher without conversion (original) (raw)

Following query does not return any rows:

MATCH (c:Channel) WHERE c.updatedAt < datetime()

But changing it to:

MATCH (c:Channel) WHERE datetime(c.updatedAt) < datetime()

returns all rows, as expected.

Tested in arcadedata/arcadedb:26.5.1, updatedAt is datetime type. I suspect this is a bug, as this should work (as mentioned in https://neo4j.com/docs/getting-started/cypher/dates-datetimes-durations/)