select * from tbl where update_time between unix_timestamp('2019-01-31 00:00:00') and unix_timestamp('2019-01-31 23:59:59') ;