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: Help with SQL statement and SUBSTR

Re: Help with SQL statement and SUBSTR

From: <norcold1_at_yahoo.com>
Date: 30 Sep 2005 08:22:51 -0700
Message-ID: <1128093771.310332.210750@g14g2000cwa.googlegroups.com> 





Ok, I am just not getting it. I've tried
TO_DATE(PCH.INSERT_DATETIME,'DD-Mon-YYYY') >='29-SEP-2005'
and


TO_DATE(PCH.INSERT_DATETIME,'DD-Mon-YYYY') >=
TO_DATE('29-Sep-2005','DD-Mon-YYYY')



but neither returns any results. I've run it without the date
parameters and there are records.



I didn't understand what you meant Sybrand. 



Thanks,


CT
Received on Fri Sep 30 2005 - 10:22:51 CDT












Original text of this message













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