Select dates less than a given year

Question

How can I create select to show only employees of a company who have been admitted to it before a certain year ?

The type anoAdmissao is date ie: dd-mm-AA

Answer 1

SELECT * FROM Tfuncionario where EXTRACT (YEAR FROM anoAdmissao) < '2000'

The Extract function was used to select only the year of the fieldAdmission, and then compare it with the desired year.

Answer 2

plain as that:

select * from tfuncionario where anoAdmissao < to_char('2000/01/01', 'yyyy/mm/dd');

using to_char to format a mask.

where '2000/01/01' corresponds to the given period of the question

Answer 3

I got it with this piece of code:

select * 
from tfuncionario F 
where F.ANOADMISSAO <= ('01/01/00');