How to remove timezone from OTBI Prompt

Question

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!!!

Pulkit Kumar Jain · Answer

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.