MX formating date differently than 5 with Oracle

[flesher_rob]

All,

We are in the process of migrating from CF5 to CFMX7. In cold fusion 5, with
an oracle databases dates are returned in the following format: "05-Apr-03",
however with the same database on our new MX7 servers the dates are being
returned in this format: "2003-04-05 00:00:00.0".

The problem is when we take the date and try to run another query using it
oracle gives an error stating that it is not a valid date(because that format
isn't a valid oracle date).

Can someone tell me if there is a server setting or something I'm missing that
would allow us to force cold fusion to use the correct oracle date format
without changing the code?

Thanks,
Rob

[TurboMini]

#createodbcdatetime(yourdate)#

[flesher_rob]

Phil,

Thanks for your reply, but we're trying to find a solution without changing
the code. This would be a pretty large effort if we had to change the code in
every place this existed. Do you have any other suggestions?

Thanks,
Rob

[Dan Bracuk]

How about the same suggestion from another person? In fact, you are going to
have to do something about this date thing everywhere you pull a date from
pretty well any database.

Just like we had to.

[A3gis]

homesite/dreamweaver find-replace feature is your buddy :)