How to remove hour in OTBI learning report?

Question

I'm trying to create a report showing learning due date and exact completion date. I would like to remove the hour that only date should be visible in the report. Is there any way to remove hour?

Riyaz Ali-Oracle · Answer

Try the below options:

* Using SQL (TRUNC Function)

If you're writing a SQL query, use:

sql

SELECT TRUNC(learning_due_date), TRUNC(completion_date)

FROM learning_table;

This removes the time portion, leaving only the MM/DD/YYYY format.

2. Adjusting the Date Format in OTBI

In Oracle Transactional Business Intelligence (OTBI), you can modify the column properties:

Go to Column Properties → Data Format.

Select Date Format and choose a format that excludes time (e.g., MM/DD/YYYY).

3. Using CAST or TO_CHAR for Formatting

you can convert the date to a string format:

sql

SELECT TO_CHAR(learning_due_date, 'MM/DD/YYYY') AS Due_Date

FROM learning_table;

Bhaskar Konar · Answer

Hi @Agnieszka Brela,

Another way you can achieve it by changing the 'Data Format' of that particular column and define it as per your requirement.

Please find below a screenshot and follow the highlighted in Yellow.

Hope this help.

Thank you.

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/25279/how-to-remove-hour-in-otbi-learning-report

Hi @Agnieszka Brela,

Welcome to the Oracle Analytics Community.

Please define your column as Date and it'll remove the timestamp. You can use syntax like following.

CAST(DUE_DATE as DATE)

DUE_DATE - Is the 'Due Date' Column.

Hope this help.

Thank you.