Date Comparison Help - Mailing list pgsql-general

Hello all,

I am rather confident that this has been answered in the past but searching for it has been a pain so I am asking for some assistance.

I need a query to get data that is 6 months older than "today" or when that query is run.

So the where clause is something like

WHERE table.date >= now() - 6 months

I know that will not work so how should I do this?