Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Date Format Error (not a valid month)

Accepted answer
31
Views
1
Comments

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:

Best Answer

Welcome!

It looks like you're new here. Sign in or register to get started.