refer to the month and year in postgresql : Hi all I'm trying to pass a script that is in mysql to PostgrSQL, but there is a sentancia this in mysql that generates me problems
is this:

    $q1="select * from noticias where month(fecha)='".$elmes."' and year(fecha)='".$elanio."'";

I get the following error:

> Warning: pg_query(): Query failed: ERROR: no existe la funciÃ³n
> month(date) LINE 1: select * from noticias where month(fecha)='03' and
> year(fech... ^ HINT: Ninguna funciÃ³n coincide en el nombre y tipos de
> argumentos. Puede ser necesario agregar conversiÃ³n explÃ­cita de
> tipos. in C:\xampp\htdocs\calendario\index.php on line 131

How do you see the month and year with postgresql?