time stamp display problem in xMII

[Former Member]

Hi,

I have Oracle 10g database connected to xMII.

When I queried for date column using xMII Query the result is like this : 12/23/2007 00:00:00.

But when I use the same Query in TOAD I am getting the expected result. i.e.. 12/23/2007 07:18:25

The datatype for Date column is "datetime".

The driver is : oracle.jdbc.driver.OracleDriver

Server Url : jdbc:oracle:thin:@<instnace>:<-->:<schema>

Package : com.lighthammer.Illuminator.connectors.IDBC

Please let me know this is problem with xMII or Oracle.

Please give me the solution.

Regards,

Suresh Hiremath

[jcgood25]

Have you searched the SAP Notes on service marketplace? - there is one that discusses this issue.

Regards,

Jeremy