If I do the example of documenting works:
SELECT EXTRACT(YEAR FROM TIMESTAMP '2001-02-16 20:38:40');
But integrating it in my query gives an error, it will be very basic, but I do not know what it is.
select
responsable,
fecha_contratado,
EXTRACT(YEAR FROM TIMESTAMP fecha_contratado) as alta
from rrhh.empleado
where responsable is not null
Thank you very much for the help Postgres 9.3
You don't need TIMESTAMP keyword in this case, try this:
select
responsable,
fecha_contratado,
EXTRACT(YEAR FROM fecha_contratado) as alta
from rrhh.empleado
where responsable is not null