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 -> Which is fastest? To_Date.. or Trunc...

Which is fastest? To_Date.. or Trunc...

From: Magnus <magnus.johansson_at_araby-dalbo.comREMOVETHIS>
Date: Fri, 30 Jul 1999 22:51:41 +0200
Message-ID: <37A2105D.C2106A39@eudoramail.comREMOVETHIS> 





Hi,



I have seen a couple of questions on comparing dates. Some recommend
To_Date and some recommend Trunc to get rid of the "time-part" of the
dates in the comparision. Does anyone know which is fastest when the
query runs?



Thanks!



/Magnus

Received on Fri Jul 30 1999 - 15:51:41 CDT












Original text of this message













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