Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

TimeStamp to Time or Date

Received Response
24
Views
3
Comments
CRX
CRX Rank 4 - Community Specialist
in Oracle Business Intelligence Applications

I have columns in the following format:

"10/10/2016 8:14:24"

How can I reduce this to "10/10/2016" or "8:14:24"

Within OBIEE 12C;

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Assuming this is for an analysis, you can change the format in the column properties.

    Example:

    pastedImage_0.png

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    BEST:  do it in ETL and store two keyed columns to join to DATE and TIME dimensions

    BETTER:  do it in the physical column mapping of a logical column in RPD

  • CRX
    CRX Rank 4 - Community Specialist

    I'll do a test and come back with an okay