How to see the time component of an Oracle 'Date' type column in TIBCO Spotfire.

How to see the time component of an Oracle 'Date' type column in TIBCO Spotfire.

book

Article ID: KB0079113

calendar_today

Updated On:

Products Versions
Spotfire Analyst All versions

Description

In Oracle, the ‘Date’ data type is represented internally as 7 or 8 bytes binary DATETIME and always have an associated time component. When such a column is fetched in Spotfire using Information Links (JDBC based connection), it gets mapped to Spotfire's 'DateTime' data type and both the Date and Time components of the data column can be visualized (say, in a table visualization) in Spotfire. However, when an Oracle connector is used for setting up a connection to Oracle data source, Spotfire maps the Oracle 'Date' data type to Spotfire's 'Date' data type (See Reference [1]). In this case, the below resolution can be followed to see the time component of the 'Date' data column.

Issue/Introduction

How to see the time component of an Oracle 'Date' type column in TIBCO Spotfire.

Environment

All supported OS versions

Resolution

To view the time component of an Oracle 'Date' data column, you can follow the below steps:
 
-    Open Spotfire Analyst and load the data table through Oracle connector.
-    Once the data gets loaded in Spotfire, click Edit Menu >> Column properties.
-    Select your data table, and the ‘Date’ column.
-    Click on ‘Formatting’ tab, and under category, select ‘Custom’.
-    Pass this format string – “MM/dd/yyyy h:mm:ss tt”
-    Click ‘OK’.
 
You should now be able to view the time part as well.

Refer to the attached gif for step by step guidance.

Additional Information

[1]Oracle Data Types: https://docs.tibco.com/pub/sfire-analyst/7.11.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/connectors/oracle/oracle_data_types.htm 

Attachments

How to see the time component of an Oracle 'Date' type column in TIBCO Spotfire. get_app
Powered by Wolken Software