'Returning Records from last 6 Months with SELECT

Lets say I have a Table of all people born this year and last year, How can I only Select the ones of the past 6 months?

I have tried this but it didn't work:

   Select * From table WHERE DateColumn >= now()-interval 6 month;

i got following error:

ORA-00904: "NOW": invalid identifier
00904. 00000 -  "%s: invalid identifier

The Data Type is Time-stamped.

oracle

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source