title: Timestamp conversion in Hive
body: <p>I would like to convert the following string value to timestamp in hive </p>
  
  <p>2016-12-31T07:09:48.507Z --> 2016-12-31 07:09:48.507</p>
  
  <p>Can you please advise me how can we do this.</p>
  
  <p>Thanks.</p>