title: how to fetch last 3 months data in hive table
body: <p>I'm using below command to fetch last 3 months data from hive.</p>
  
  <p>select * from xyz where creat_ts between '2017-01-06 00:00:00' and '2017-03-06 23:59:59';</p>
  
  <p>how to fetch last 3 months data in hive without using between keyword.</p>