FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMar 4, '96 at 8:49p
activeMar 4, '96 at 8:49p
posts1
users1
websiteoracle.com

1 user in discussion

Charles Dye PC: 1 post

People

Translate

site design / logo © 2022 Grokbase