Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Dates as numbers
//Adding dates as numbers
load csv with headers from
"" as csv
create (p:Person {name: csv.Name, birthdate: toInt(substring(csv.Birthdate,0,2))+toInt(substring(csv.Birthdate,3,2))*100 + toInt(substring(csv.Birthdate,6,4))*10000});
Name Birthdate
Rik Van Bruggen 23-10-1973
Katleen Goossens 24-10-1973
Mit Van Bruggen 16-04-2003
Toon Van Bruggen 24-05-2005
Cas Van Bruggen 31-05-2009
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment