How to remove timezone from OTBI Prompt — Oracle Analytics

Oracle Transactional Business Intelligence

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

Categories

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

How to remove timezone from OTBI Prompt

Received Response
625
Views
1
Comments
Praveen_Chouhan
Praveen_Chouhan Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

Hi,

I have created OTBI analysis using custom SQL.I have taken the following Subject area

Learning Management real Time , Person Real Time , Learning Records real time.

The prompt pulls Timezone also.I have attached ss of it below

Can anyone help me how can i remove the timezone from the prompt date????


Thanks in advance!!!

Tagged:

Answers

  • Pulkit Kumar Jain
    Pulkit Kumar Jain Rank 3 - Community Apprentice

    Hi,

    Please use the "CAST" function to remove the timestamp from the date.

    Please find the below Example.

    CAST("Ledger"."Ledger Last Update Date" AS DATE)

    Please find the below image for Reference.