Last active
August 29, 2015 14:22
-
-
Save rvanbruggen/39be473ef3d69ce9a316 to your computer and use it in GitHub Desktop.
Dates as numbers
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//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}); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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