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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with order in WHERE statement

Re: Problem with order in WHERE statement

From: Nicolas Bronke <Nicolas.Bronke_at_t-online.de>
Date: 1998/03/03
Message-ID: <6dhoc5$hlg$1@news02.btx.dtag.de>#1/1 







Try using more brackets around the clauses 
e.g. 


(TST_EQUAL(tst, to_date('25-02-1998 18:13:19',


> 'DD-MM-YYYY HH24:MI:SS')) = 0) AND (id = 5)

or


(id = 5) AND (TST_EQUAL(tst, to_date('25-02-1998


> 18:13:19', 'DD-MM-YYYY HH24:MI:SS')) = 0)


Regards
Received on Tue Mar 03 1998 - 00:00:00 CST












Original text of this message













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