Extract year from postgres date

Question

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

While I think @OtoShavadze has it solved in his answer, it would be VERY helpful to share the error you are getting in the future. — JNevill
– JNevill, Commented Apr 18, 2017 at 17:49

Oto Shavadze · Accepted Answer · 2017-04-18 17:48:34Z

1

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

answered Apr 18, 2017 at 17:48

Oto Shavadze

43.3k56 gold badges169 silver badges248 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1