您的问题还不完全清楚，但据我所知，您希望使用impala/python日期时间函数来自动执行查询，以选择一天的数据。下面是我的例子，你可以做在 Impala 。

-- to_date - function will cut the date from timestamp
-- now()   - gives you the current timestamp

select to_date(now()) as currentDate, 
to_date(now() + interval 1 days) as currentDatePlusaDay, 
now() as currentTimestamp, 
now() + interval 1 day as currentTimestampPlusaDay, 
concat(to_date(now() - interval 1 days), ' 00:00:00') as whereBetweenMin, 
concat(to_date(now() - interval 1 days), ' 24:00:00') as whereBetweenMax ;

--Result

+-------------+---------------------+-------------------------------+-------------------------------+---------------------+---------------------+
| currentdate | currentdateplusaday | currenttimestamp              | currenttimestampplusaday      | wherebetweenmin     | wherebetweenmax     |
+-------------+---------------------+-------------------------------+-------------------------------+---------------------+---------------------+
| 2018-03-23  | 2018-03-24          | 2018-03-23 12:14:36.073281000 | 2018-03-24 12:14:36.073281000 | 2018-03-22 00:00:00 | 2018-03-22 24:00:00 |
+-------------+---------------------+-------------------------------+-------------------------------+---------------------+---------------------+

--You can probably use wherebetweenmin & wherebetweenmax