Select by date

select * from table where entry_date > now() - interval '6 month';

Did this page help you?