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