My Oracle Support Banner

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.