Symptom
Using the to_char function on a date field always returns a lower case result in an Oracle database.
For example, the syntax is:
to_char(DATE_VALUE, FORMAT)
The FORMAT argument is like 'Mon', 'mon' or 'MON'. The above syntax should be pushed down to Oracle and the expected output is like the Oracle to_char function. However, the output is always lower case.
Read more...
Product
SAP Data Integrator XI
Keywords
Data Integrator, to_char, Oracle, date, lower DI , 5488837 , KBA , EIM-DI , Data Integrator, Composer , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.