Error: Date and time information returns unexpected results - during Query and Output Processing

When updating the code to show the time portion of a date/time field in an output, the data returned in the output does not match what is shown in the application, specifically the time seems formatted wrong.
When modifying how a date/time value is formatted in an output, if the value seems incorrect, check the values that were entered into the output when modifying the date format.  For instance, the format to specify minutes is MI not MM (which is month).  For further information on setting data formats in SQL see http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm.

Environment

 Team Approach
 RSR
 TA

Was this article helpful?