Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> These WHERE clause are equal ?

These WHERE clause are equal ?

From: R Chin <rchin_at_ictgroup.com>
Date: Tue, 26 Feb 2002 15:08:19 -0500
Message-ID: <a5gq04$gg5$1@reader2.panix.com> 





Are the WHERE clauses below equivalent ?



stamp_date  has time stamp (ie '02/08/2002 12:57:51 PM')
and I don't care about the time.



Case 1)


select * from TBL_LOG


where TRUNC(stamp_date) BETWEEN '04-FEB-2002' AND '09-FEB-2002'



Case 2)


select * from TBL_LOG


stamp_date BETWEEN  TO_DATE('04-FEB-2002') AND TO_DATE('09-FEB-2002') +
.99999




rowid comparison seems to match.



Thanks
Received on Tue Feb 26 2002 - 14:08:19 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US