title: Hive: how to convert yyyy-mm-ddThh:mm:SS:sssZ into hour units
body: <p>I have the following timestamps:</p>
  
  <pre><code>2020-03-09T07:34:06:825Z
  2020-03-09T07:54:12:220Z
  2020-03-09T03:54:11:041Z
  2020-03-09T09:22:10:220Z
  2020-03-09T11:13:36:217Z
  2020-03-09T11:23:26:040Z
  2020-03-09T11:43:35:721Z
  </code></pre>
  
  <p>And I would like to convert them in hourly unit such as:</p>
  
  <pre><code>2020-03-09T07:00:00
  2020-03-09T07:00:00
  2020-03-09T03:00:00
  2020-03-09T09:00:00
  2020-03-09T11:00:00
  2020-03-09T11:00:00
  2020-03-09T11:00:00
  </code></pre>
  
  <p>Will this be possible? Any help will be appreciate. Stackoverflow has been a life saver. It could be in datetime or string format.
  Thank you all!</p>