compare dates

[chrisrlong]

Yea, verily!!

Well spoken, brother Jurij!!!!

This would make your query:

select ename from emp
where hiredate > TO_DATE('17/02/99', 'DD/MM/YY')

Of course, since you never want to specify only 2-digit years either, might I suggest:

select ename from emp
where hiredate > TO_DATE('17/02/1999', 'DD/MM/YYYY')

- Chris