on 01-24-2008 8:19 AM
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
Have you searched the SAP Notes on service marketplace? - there is one that discusses this issue.
Regards,
Jeremy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
4 | |
4 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.