How to filter date using query entity?

Hi All,

I have a scenario where i need to filter the data from db based on the date. Filter values will be something like below.

Today

Yesterday

Last 7 days

Last 30 days

FYI,

In Db,  date column is stored in date time format. I’m able to achieve it if the date is stored in date formate rather that date time.  

Can an someone suggest me how to achieve the filtering thing from db based on the date when db value is date time?

Thanks in advance