Categories
- All Categories
- Oracle Analytics Learning Hub
- 18 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 228 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 85 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
Best Answer
-
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
0
![[Deleted User]](https://us.v-cdn.net/6037859/uploads/defaultavatar/nT2GKTLRQJ3P1.jpg)
Answers
-
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?
0 -
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
0 -
OK, thanks a lot
0