You are hitting an issue with the DATE format used in Oracle 10g. iDashboards reads the date information correctly, however the time info is being ignored; data coming into the chart is being reset to midnight of the specified date while the database contains the exact time information. A standard SQL query returns the proper time detail. The Oracle DB is version 10.2.0.5, and you are connecting to it via the Oracle 10g Release 2 thin driver.
How do I ensure the time as well as date info is pulled through into iDashboards?
This is a compatibility issue with Oracle 10g that was rolled back in 11g and later versions.
Check out the Oracle link below for details on how to correct for this issue: