Hi,

I have the following two sql statements:

1. select empno from emp where employed_date < sysdate -60 order by employed_date;

2. select empno from emp where employed_date < sysdate -60;

When I run statement 1, I get the right results, which give me all empno hired 2 months ago.
But statement number 2 returns record of empno hired one month ago. Seems like the where clause does not work properly here.

Any help will be greatly appreciated.