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 -> SELECT on part of a date field

SELECT on part of a date field

From: Zorglub <no_at_mail>
Date: 30 Jan 2002 11:12:06 GMT
Message-ID: <Xns91A67C3ECE677zorglubID1923@213.228.0.32> 





Hello, here is my select statement :


SELECT * FROM ACTUALITE WHERE TO_CHAR(DateCrea,'MM')=1 AND TO_CHAR
(DateCrea,'YYYY') = 2002 ORDER By Categorie, DateCrea DESC



DATE_CREA is a field of the table ;-)



Is it the best way to search for the part of a date (I mean, the fastest !)



Thanks
Received on Wed Jan 30 2002 - 05:12:06 CST












Original text of this message













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