Re: ORA-01722
From: VD <vincentdesnoyer_at_yahoo.fr>
Date: Thu, 7 Sep 2000 17:10:02 +0200
Message-ID: <8p8b16$r65$1_at_s6.asi.fr>
='20000630';
Date: Thu, 7 Sep 2000 17:10:02 +0200
Message-ID: <8p8b16$r65$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:10:02 CEST