I don't know if this is exactly your problem, but the string formatting
of dates is controlled by the "locale" of the oracle server. It could
be set for a locale that just returns this.
What we generally do for Oracle dates using native drivers is to turn
the dates into a string when we select them:
SELECT TO_CHAR(YourDateField, "MM/DD/YYYY HH24:MI:SS") AS YourDateField,
....
This way, we can format the dates exactly how we expect them to be.
Stefan wrote:
>
> Does anyone know of a problem with the native oracle drivers in CF4.5.1
> Enterprise? If the native driver is used and dates are selected, only the
> day and month are passed to CF. If ODBC is used, everything works correctly.
>
> The system runs CF Enterprise 4.5.1 (no SP) on NT4.0SP6a, Oracle 8.1.5 on
> NT40.0SP6a
>
> Thanks,
>
> Stefan
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists