Hello there, I am loading the data from a sample CSV into Employee. The CSV has 2 columns - birthdate and hiredate. The code is like this - load csv with headers from 'file:///northwind/employees2.csv' as row merge(c:Country {country : row.country}) merge(e:Employee { employeeId:toInteger(row.e…

I have the same issue. Did you end up solving it? It seems that the datetime() function requires a hardcoded timestamp value rather than a variable or alias

@ameyasoft I'm not sure about OP's value, but mine is 1609283699032, and the query giving me the Cannot construct date time from: NO_VALUE error is the one below match (n:MyNode) with date(datetime({epochmillis: n.timestamp})) as r return r where n.timestamp is the value 1609283699032

[image] asharpe: 1609283699032 .csv file stores all values as strings. While importing, one needs to use toInteger function and that stores the property value as integer. Here is the workaround sample: with '1609283699032' as tme with date(datetime({epochmillis: toInteger(tme)})) as r ret…

@ameyasoft thank you! For anyone who reads this in the future: After trying out ameyasoft's solution, I discovered that passing in a string timestamp could also produce this different error: Cannot construct date time from: String("1609283699032") , which is more informative than the first error …

CURRENT SUBMISSIONS ✦ @mabu.mate Apple HealthGraph Agent ✦ @venkatasaiprasadp DepGraph Agent ✦ @dhiraj.patra RegulatoryRisk GraphAgent ✦ @shantanunitw01 CineGraph AI ✦ @jevlachov Korca Triage Agent ✦ @deanfoulds Japan Seismic Risk Intelligence Graph ✦ @jonas.koenner ConspiracyGraph Agent ✦ @mahanteshimath FinSight ✦ @prashant7090 Detect Cyber Attack ✦ @ochiengokumu482 VAT-TaxGraph AI ✦ @shrikantbhadane Aura-Health-Bot ✦ @violet.ols.dev RecallScope Agent ✦ @tarunnarang1992 ReviewGraph AI ✦ @epiphanyan Earnings Call Graph Analyst ✦ @wanga.15065 M-Pesa (Kenya) Insight Agent ✦ @kumar20051020shivam VibeGraph AI ✦ @jakub.kierznowskiii DrugPath ✦ @vinod.nageshwar Geospatial Supply Chain Agent ✦ @winleexz CPF Customer Agent ✦ @hellopriyanshu4 FraudGraph Sentinel ✦ Submit your Aura Agent Project to appear here

Neo4j Online Community

Cannot construct date time from: NO_VALUE (Failure when processing file

Neo4j Graph Platform Procedures & APOC

ameyasoft ( Ameyasoft) August 16, 2021, 6:38pm 3

Please post the date value as in your .csv file so that I can suggest a solution

Topic		Replies	Views
Loading csv with date fields and default values Cypher apoc , cypher , import	3	131	November 14, 2024
Import csv format issue: convert str date to datetime format Import / Export	2	174	June 17, 2024
Datetime issue - Import data from SQL Server ETL-Tool	8	4215	November 4, 2020
How to change string in to datetime type? Import / Export import	2	2950	April 7, 2020
How to read date time value not separated by T? Cypher apoc	2	956	January 5, 2019

Take the Course Then Join The Aura Agent Hackathon

Cannot construct date time from: NO_VALUE (Failure when processing file

Related topics

Take the Course Then Join
The Aura Agent Hackathon