different result 1

[Ravala]

We have two servers: development and production.
I run this sql:
select DATE_LAST_USED
from inventory
where item_code='125-325'
and DATE_LAST_USED <=TO_DATE('07081997','mmddyyyy') ;

on development i have: no row selected,
and on production I have:
DATE_LAST
---------
02-AUG-04
What could be a reason?

Thanks.

 

[sem]

Why do you thing that both servers hold the same data???

Regards, Dima

http://seminihin.narod.ru

 

[Ravala]

select DATE_LAST_USED
from inventory
where item_code='125-325';

i have:
DATE_LAST
---------
12-AUG-04

 

[sem]

What is DATE_LAST_USED datatype? Is it DATE? If so, please post the results of

select to_char(DATE_LAST_USED,'DD.MM.YYYY') 
  from inventory
 where item_code='125-325';

Regards, Dima

http://seminihin.narod.ru