Skip to content

Instantly share code, notes, and snippets.

@rvanbruggen

rvanbruggen/datesasnumbers..cql

Last active August 29, 2015 14:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rvanbruggen/39be473ef3d69ce9a316 to your computer and use it in GitHub Desktop.
Save rvanbruggen/39be473ef3d69ce9a316 to your computer and use it in GitHub Desktop.
Download ZIP
Dates as numbers
Raw
datesasnumbers..cql
//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});
Raw
source.csv
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