Re: Comparing 2 dates

From: Yvan Galas <yvan.galas_at_fr.adp.com>
Date: Fri, 28 Jan 2000 13:31:07 GMT
Message-ID: <38919A2F.137EA31C@fr.adp.com>

Nicky Taylor wrote:
>
> I have a 8 character string field which represents a date in the format
> 'YYYYMMDD' and I have a date field. I am trying to subtract one from the
> other by doing a TO_DATE on both fields with the format 'YYYYMMDD'. i.e.
>
> TO_DATE(date1,'YYYYMMDD') - TO_DATE(date2,'YYYYMMDD'))
>
> I keep getting ORA errors complaining about the formatting.
>
> Any help appreciated.
>
> Nicky.

Hi,

Do you manipulate Y2K date ??? if yes you can change YYYY by RRRR

Zoil. Received on Fri Jan 28 2000 - 07:31:07 CST