Queries in PostgreSQL question ???

[e2interactive]

I am trying to makes some queries using a PostgreSQL database and I'm having issues with my SQL statements. I normally work with mySQL database and can translate most queries with no issues. I used this query the other day and cannot for the life of me figure out how to query this in PostgreSQL.

$query1 = "SELECT * FROM table_name WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_field";

The date_field in the PostgreSQL is a DATE field and I want to get all fields that have been added to the database in the last 30 days. This query works in a mySQL DB but i get an error using it in a PostgreSQL DB. How would you create this query for a PostgreSQL Database?

[eoghain]

Well first off I'd check out the PostgreSQL documentation on date time functions (http://www.postgresql.org/docs/7.4/static/functions-datetime.html). And after reading that it looks like your query should be something like this:

SELECT * 
  FROM table_name 
 WHERE CURRENT_DATE - INTERVAL '30 DAY' <= date_field";

[e2interactive]

that query did the trick, thanks