Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Date Format Error (not a valid month)
ashraf817
Rank 3 - Community Apprentice
Hello,
I am experiencing an issue with the 'Done Time' column where the day is being interpreted as the month. Although the format in the database appears to be correct, Oracle Analytics Desktop seems to misinterpret it. I have attempted to adjust the format within Oracle Analytics, but the issue persists. Could you please help?
thank you
TO_CHAR(TO_DATE(d3.the_dt, 'DD-MM-YYYY HH24:MI:SS'), 'DD-MM-YYYY HH24:MI:SS') AS the_dt
Tagged:
0
Best Answer
-
@ashraf817 Can you set the date format in DV as MM/dd/yyyy hh:mm:ss and check?
0
