Neo4j Admin Import Tool w/ epoch column values

(Sean R Graff) #1

Hello,

I have a CSV w/ a column whose values are time since epoch entries. (So longs, basically). I'd like to do something like this:

insertDate:datetime{epochMillis}, otherAtts
123456123, another attribute

Is this possible? Or will I need to do it post import, or change the CSV file pre-import to be read-able values?

Thanks,
Sean

0 Likes

(Ameyasoft) #2

During import itself you can convert epoch time:

apoc.date.format((ToInteger("1449158574")),('s'), ('yyyy/MM/dd'), ('PST')) as dates
Result: 2015/12/03
PST is the time zone.

Replace "1449158574" with your epoch time like line.epochMillis in your .csv import.

0 Likes