0
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.
0
2
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.
1
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
0
I got it with this piece of code:
select *
from tfuncionario F
where F.ANOADMISSAO <= ('01/01/00');
Browser other questions tagged sql oracle pl-sql
You are not signed in. Login or sign up in order to post.
show, it is good to use to_char to guarantee values
– Julio Henrique
This sql may give error if the "Section" parameters have been changed.
– Motta