cordialy
Steff
-----Message d'origine-----
De : Simon Whittaker [mailto:[EMAIL PROTECTED]
Envoyé : Tuesday, July 20, 2004 10:37 AM
À : CF-Talk
Objet : Re: cf mx and oracle 8i
On Tue, 20 Jul 2004 10:32:35 +0200, Steff <[EMAIL PROTECTED]> wrote:
> I think where is the problem, I get date values with a query. The table
> value is like 19-JUL-04. Coldfusion gives me a date like '2004-07-19
> 00:00:00.0' to_date can't convert. So I should certainly before insert
> query, modify the date to obtain the right format.
That is right - try something like the following:
to_date('#dateformat(date_from_query,"DD/MM/YYYY")#','DD/MM/YYYY')
Should work okay for you
Cheers
Simon
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
