In Oracle, the DATE data type is commonly used to store both a date and time in a table. For example, an Oracle DATE column could be used to store the value '2007-08-17 15:42:40'. Under some circumstances, when iDashboards reads data from an Oracle DATE column, only the date portion (year-month-day) is returned, and the time component is truncated, which means the value above would be read as '2007-08-17 00:00:00. This document explains how to troubleshoot and fix this problem.
Please see the attached document for more information.
- X Platform
- Enterprise Suite