Oracle Communities

Oracle Analytics and AI

Child Item

Can FMT be included in the CAST function? or set the internal date format in a data set?

Hello everyone!
A few days ago there was apparently a change in Analytics and since then, the data sets (based on excel or csv), now internally store the date format differently (only those created again or refreshed have this change).

Before (in my case) the format was something like: 'YYYY/MM/DD HH24:MI:SS'

with which cast (a date field xx like '04/27/2021' as char) = '2021/04/27'

and now, cast (a date field xx like '04/27/2021' as char ) = '27/apr/21'

This causes calculations like cast( a text string like '2021/04/27' as date) they no longer work.

The question is if you know where you can configure the internal format of the date field, to force it to continue being 'YYYY/MM/DD HH24:MI:SS', I tried to look in:
Console / System Configuration / Format

But I didn't find anything,
Any help would be welcome!!

Saludos Rafael

Find more posts tagged with

Analytics

Calculation

Accepted answers

[Deleted User]

If only the September release was applied then please raise a Service Request.

Your interpretation of dates should not have changed as far as I know

All comments

[Deleted User]

there was apparently a change in Analytics

@user7093388 could you be more specific? Which analytics? OAS or OAC? If it's OAC then did you get any emails on your instance getting upgraded? If it's OAS what did your implementation / admin team change?

user7093388

Hello, thank you very much for the response!

It is OAC, version updated as of September 2024. Brazil region I did read the updates and improvements and I am already using them.

As an update, to minimize the problem I am reviewing dashboards and reports and minimizing the use of text-to-DATE conversions, some users used a text parameter for example period (text) = '2024/09', I helped them replace it with a date type parameter and adapt the calculations, eliminating conversions and simplifying the complexity they had and thus solving the problem.

Slds

Rafael

[Deleted User]

If only the September release was applied then please raise a Service Request.

Your interpretation of dates should not have changed as far as I know

user7093388

OK, thanks a lot