IBM Business Analytics

 View Only
Back to discussions
Expand all | Collapse all

Oracle date fields (date/time) received in data module as char type fields

  • 1.  Oracle date fields (date/time) received in data module as char type fields

    Posted Fri January 06, 2023 03:18 PM
    Edited by Portia Melita Mon January 09, 2023 11:08 AM
    I have an Oracle table that was created by import function using sql developer. The date fields are fully functional in Oracle.
    But when i use this table in a data module, all the date fields are converted to character fields.
    On screen the content of the date fields is presented in the format:
    dd/MM/yyyyThh:mm:ss.

    What can be wrong? Why is the oracle date-field not recognized/converted as such?

    Anybody a clue?

    Thanks in advance
    Best regards 
    Mike


    ------------------------------
    Mike Albers
    ------------------------------


  • 2.  RE: Oracle date fields (date/time) received in data module as char type fields

    Posted Tue February 21, 2023 04:26 PM

    I'm pretty sure I've encountered this headache before.  So that I may find the solution I've used in the past, can you clarify how your data module is obtaining data from the table you imported to the Oracle database using SQL Developer?  They solution may differ if you:

    • Imported table to DB via SQL Developer; added table to package in Framework Manager; published package; created a dataset; put the dataset into a module.
    • Imported table to DB via SQL Developer; did NOT add table to package in Framework manager; created a dataset using SQL written in Cognos; put the dataset into a module.


    ------------------------------
    Logan Whitaker
    ------------------------------

    Original Message