title: Merging two columns in hive and use between operator
body: <p>I have a login details table in hive with columns </p>
  
  <p><strong>(DATE, TIME, USER)</strong></p>
  
  <p>I am trying to write a query which can select users who have logged in between two dates with time also taking in consideration. For example: I want to know the users who have logged in between <code>10-12-2012</code> <code>02:30:00</code> and <code>28-12-2012</code> <code>16:20:00</code>. Dates in <code>DD-MM-YYYY</code> and Time in <code>HH:MM:SS</code> format.</p>
  
  <p>I am able to execute </p>
  
  <pre><code>select * from test_table where time between "02:30:00" and "16:20:00" ;
  
  select * from test_table where date between "10-12-2012" and "28-12-2012" ;
  </code></pre>
  
  <p>But i am not getting how to take both date and time columns into consideration while fetching the required result. Please guide me. Thanks in advance</p>