Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Dates as numbers
//Adding dates as numbers
load csv with headers from
"https://gist.githubusercontent.com/rvanbruggen/39be473ef3d69ce9a316/raw/24e9d5470abbfbe60d7fedb2005117a5259090d9/source.csv" 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
You can’t perform that action at this time.