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: LIKE Clause with dates?

Re: LIKE Clause with dates?

From: Mark G <mgumbs_at_nospam.hotmail.com>
Date: Fri, 25 Jun 1999 09:10:46 +0100
Message-ID: <3773372e.0@145.227.194.253> 





What is this analog test?



Is it freely availiable?



M



>David J. Hazledine: (1)


>where datepart between to_date('01'||to_char(asofdate,'MMYYYY'),'DDMMYYYY')


>and last_day(asofdate)


>


>analog test:


>select count(*) from atable where datepart between trunc(AsOfDate,'mm') and


>last_day(AsOfDate)


>result :1729 of 9696 recs / 0.02 sec !!! EXCELLENT


>





Received on Fri Jun 25 1999 - 03:10:46 CDT












Original text of this message













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