Simple Query, WRONG Answer:

From: Charles Dye PC <cdye_at_DNT.DIALOG.COM>
Date: Tue, 5 Mar 1996 20:41:19 -0500
Message-Id: <9603050149.AA29560@alice.jcc.com>

All,

Please look at this and tell me what I am missing. I say this query is getting  the wrong results. The trans_start field is a DATE field, and we don't have  any weird NLS_DATE stuff turned on:

Regards,
Charles_Dye_at_corp.dialog.com

SQL> l
  1 select trans_id, trans_start
  2 from pcn_trans_log_archive
  3* where trans_id = 10549810
SQL> /   TRANS_ID TRANS_STA
---------- ---------

  10549810 04-MAR-96
  10549810 04-MAR-96 SQL> select sysdate from dual;

SYSDATE

---

05-MAR-96 SQL> select trans_id, trans_start
  2 from pcn_trans_log_archive
  3 where trans_start > sysdate-5
  4 /

no rows selected

SQL> select max(trans_start)
  2 from pcn_trans_log_archive;

MAX(TRANS

---

24-DEC-95 Received on Mon Mar 04 1996 - 20:49:27 CST