Timestamp Shows 00:00 When Using Oracle JDBC 10.1.0.5
(Doc ID 360422.1)
Last updated on OCTOBER 28, 2019
Applies to:JDBC - Version 10.1.0.5 and later
Information in this document applies to any platform.
You are trying to use Oracle JDBC 10.1.0.5 through oracle.jdbc.OracleDriver data source in macromedia codefusion 6.0;
JDBC URL: jdbc: oracle: oci:@myservice;
Driver Class: oracle.jdbc.OracleDriver
Everything works well except that when retrieving date fields from oracle database 10.1.0.5, the timestamp comes back as 00:00:00. With Oracle 9 drivers or 10.1.0.3, the timestamp is available.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document