Question

Views

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

over 4 years ago · Santiago Trujillo

Answer question

Accepted Answer · 2022-05-26T13:36:04.571Z

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