This query which works with mySQL doesn't work with Postgresql:

select ... from ... where (id = ... and ( h > date_sub(now(), INTERVAL 30 MINUTE)))

The error is:

Query failed: ERREUR:  erreur de syntaxe sur ou près de « 30 »

Any ideas ?

sql postgresql
Edit
Report