IBM Support

SQL query returns incorrect date format

Troubleshooting


Problem

A SQL Query action in IBM Rational Integration Tester (RIT) returns a TIMESTAMP value in the form of 2016-03-14 11:40:19.0 when a different format is required

Symptom

Consider the following Oracle table structure:
image 1552
See the following SQL statement and result:
image 1553
You wish to return the data in a different format.

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSBLQQ","label":"IBM Rational Test Workbench"},"Component":"Rational Integration Tester","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
17 September 2019

UID

ibm11073942