You need to use to_date as this is used by Oracle to convert your date
from a string into the correct format. Have you tried the re-ordering
I suggested?
to_date('19/07/2004', 'dd/mm/yyyy')
Cheers
Simon
On Tue, 20 Jul 2004 10:20:05 +0200, Steff <[EMAIL PROTECTED]> wrote:
> I try and I obtain ORA-00932: inconsistent datatypes
> Can you help me?
> thanks
> steff
> -----Message d'origine-----
> De : Micha Schopman [mailto:[EMAIL PROTECTED]
> Envoyé : Tuesday, July 20, 2004 10:06 AM
> À : CF-Talk
> Objet : RE: cf mx and oracle 8i
>
>
> Try using createODBCDateTime() to specify a dateobject, instead of
> to_date()
>
> Micha Schopman
> Software Engineer
> Modern Media, Databankweg 12 M, 3821 AL Amersfoort
> Tel 033-4535377, Fax 033-4535388
> KvK Amersfoort 39081679, Rabo 39.48.05.380
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
