Oracle Date/Timestamp issue

[Greg Campbell]

I've got my first CF app with an Oracle database (10g Rel 2.).
When I retrieve a date type field (including hour, minutes, and seconds) it
gets truncated to just date (seen via cfdump).
When I alter the table column to type timestamp, when it comes back I get an
error:
Unable to convert type oracle.sql.Timestamp to date.

There is an Oracle FAQ that says starting with 9.2 in jdbc, the DATE field
are mapped to java.sql.Date and the Timestamp fields are mapped to
java.sql.Timestamp. And java.sql.Date does not include hours, mins, seconds.
Prior to 9.2 Oracle date was mapped to timestamp. I understand that Oracle DATE
field do not inlcude fractions of seconds, where Timestamp fields do.

All I want is the hour, minutes, and seconds without splitting up the data
into a date field and a time field in my database.
I'm using Oracle jdc 10.2 tar. Is there a configuration to map the Oracle Date
or Timestamp types to a date field where I can use CFs DateFormat and
TimeFormat.

[Greg Campbell]

Duh, thoroughly seach the forum before posting.

OK, so the solution (for most) appears to be add this to the CF Admin JVM
settings:
-Doracle.jdbc.V8Compatible=true
,including the leading dash.

It worked for me!

[Anton Thorn]

So were you not able to use Coldfusion's DateFormat() and TimeFormat() functions before adding that line to the ColdFusion Admin JVM settings?