0
To extract the year you can use:
SELECT idFuncionario, nomeFuncionario, anoAdmissao, EXTRACT (YEAR FROM anoAdmissao) AS ano FROM Tfuncionario
If you want to select who is completing a year today can use:
SELECT Tfuncionario.* WHERE Mod(Trunc(sysdate) - Tfuncionario.anoAdmissao, 365 ) = 0
I can automate with sydate ?
– alexjosesilva
make one year after being added ?
– alexjosesilva
Select all employees who complete today one year of admission ?
– alexjosesilva
yes, yes and yes @alexjosesilva
– Julio Henrique