Timestamp Shows 00:00 When Using Oracle JDBC

(Doc ID 360422.1)

Last updated on OCTOBER 06, 2010

Applies to:

JDBC - Version: and later   [Release: 10.1 and later ]
Information in this document applies to any platform.


You are trying to use Oracle JDBC 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, the timestamp comes back as 00:00:00. With Oracle 9 drivers or, the timestamp is available.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms