title: Comparing dates in hive not returning what expected
body: <p>I'm doing some comparison with dates, and when I do the following:</p>
  
  <pre><code>from_unixtime(unix_timestamp(a11.duedate),'dd-MM-yyyy') &lt; 
  from_unixtime(unix_timestamp(),'dd-MM-yyyy')
  </code></pre>
  
  <p><strong>returns false</strong></p>
  
  <p>The a11.duedate is 21-02-2018 and is returning false when comparing with today's date.</p>
  
  <p>When I compare it in miliseconds, <strong>returns true</strong>:</p>
  
  <pre><code>unix_timestamp(a11.duedate) &lt; unix_timestamp()
  </code></pre>
  
  <p>What I am missing here? In my view, both conditions should return true.</p>