title: how to convert string into timestamp in neo4j
body: <p>I have loaded timestamps in string format using a CSV into Neo4j as I didnt know how to set them to date time format from the beginning. I then found a way to use "split" function on strings to then convert it to integers and then datetime and i got most of it working apart from small issues</p>
  
  <p>I have tried splitting the date bit by "-" and time by ":", but I am not sure how to deal with a space between date and time that makes my soluition not working well</p>
  
  <pre><code>MATCH (p:event)
  WITH p, [x IN split(p.tstamp, "-") | toInteger(x)] AS parts
  WITH p,parts,   [y IN split(p.tstamp, ":") | toInteger(y)] AS timeparts
  
  SET p.timestamp = datetime({day: parts[2], month: parts[1], year: parts[0], hour: timeparts[0], minute:timeparts [1], second:timeparts[2] 
  });
  </code></pre>
  
  <p>The original timestamp example is:</p>
  
  <pre><code>//original timestamp
  09/01/2019 17:34:58.0000
  </code></pre>
  
  <p>I expected to have e.g:</p>
  
  <pre><code>//e.timestamp           
  09/01/2019 17:34:58 
  </code></pre>
  
  <p>But I got:</p>
  
  <pre><code>//e.timestamp            
  "2019-01-01T00:34:58Z"
  </code></pre>