title: Conversion Hive datediff() to months
body: <p>When using <strong>Hive</strong> there is the functionality to return the <code>select datediff('date1','date2') from table</code> value which returns the number of days between two dates.
  What if I would be interested in the months between the two dates?  </p>
  
  <p>One option would be to divide the result by 30.5, as the average months has approximately 30.5 days, but this would certainly yield an inprecision when large date ranges are considered.</p>
  
  <p>Do you know a way of retrieving the <strong>number of months</strong> (rather than the number of days) in a similar fashion with standard SQL (ideally HIVE) syntax?</p>