Re: ORA-01722

From: VD <vincentdesnoyer_at_yahoo.fr>
Date: Thu, 7 Sep 2000 17:08:11 +0200
Message-ID: <8p8atl$r64$1_at_s6.asi.fr>


> select asset, barcode from value
> where

        to_char(
                        to_date('17991231','yyyymmdd')        DATE
                        +
                        to_number(valdate),
NUMBER
                  'yyyymmdd')
        ='20000630';

That's no work because
        DATE+NUMBER isn't a DATE

What do you want to do?

--
"Soyez sport, Donnez votre Sang !"
Etablissement Français su Sang
0.801.150.150 ou 3614 Don du Sang
http://www.efs.sante.fr/
Received on Thu Sep 07 2000 - 17:08:11 CEST

Original text of this message