Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
10-02-2020 09:13 PM
I can execute the following command in neo4j Sandbox, neo4j desktop of Linux(ubuntu 18), but when I execute it in Neo4j desktop for mac OS
return apoc.date.parse('Jul 12, 2019', 's', 'MMM dd, yyyy')
I get the following error
Failed to invoke function `apoc.date.parse`: Caused by: java.text.ParseException: Unparseable date: "Jul 12, 2019"
I have tried this on server 4.1.1, 4.1.0, 4.1.2, 3.5.17, all of them not working.
My Neo4j Desktop is v1.3.8.
10-03-2020 03:11 AM
Let me ask the "is the machine plugged in" question. Do you have APOC procedures installed on your instance? If not, you may not have access to them, as APOC isn't installed by default. In case it's not there you can follow these steps https://neo4j.com/developer/neo4j-apoc/ to install it.
10-03-2020 06:38 AM
Yes, I can run the function apoc.load.json in the same machine without any problem.
10-03-2020 10:16 PM
Try this:
RETURN apoc.date.format(apoc.date.parse('Jul 12, 2019', 'ms', 'MMM dd, yyyy'), 'ms', 'yyyy-MM-dd')
Result:
"2019-07-12"
10-04-2020 06:21 AM
Hi Sen,
I reassure you, this problem occurs also in Neo4j aura. For the moment, i didn’t dive on this issue. I kept as à string for now the value. The alternative is to using substring.
Br
All the sessions of the conference are now available online