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>
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