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.

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. 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. [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