Re: Help with SQL statement and SUBSTR

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Fri, 30 Sep 2005 15:27:22 GMT
Message-ID: <Xns96E15606C839ASunnySD@68.6.19.6>

norcold1_at_yahoo.com wrote in
news:1128093771.310332.210750_at_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
>
>

PCH.INSERT_DATETIME >= TO_DATE('29-Sep-2005','DD-Mon-YYYY') Received on Fri Sep 30 2005 - 10:27:22 CDT