title: How to convert ISO Date to UTC date in Hive
body: <p>I have JSON data as below: I need to convert that date or <code>mongo_date</code> into utc timestamp, to analyse the data in hive as per timeline example per year, per month, per week using map reduce </p>
  
  <pre><code>{
      "_id" : ObjectId("51ac77050e9edcdad271ce2d"),
      "company" : null,
      "date" : "19760224",
      "mongo_date" : ISODate("1976-02-24T00:00:00Z")
  </code></pre>