title: Filter by time and date in Hadoop
body: <p>I have a table of data which have date and time as two separate field where date format is </p>
  
  <p>dd/mm/yyyy and dd-mm-yyyy and time format is like hh:mm:ss(eg: 6:52:53)</p>
  
  <p>i need to filter the record for a particular time period that both time and date wise filtering. </p>
  
  <p>is there any predefined filter available with hive or pig? </p>