Date Format Error (not a valid month)

Question

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

BalagurunathanBagavathy-Oracle · Accepted Answer

@ashraf817 Can you set the date format in DV as MM/dd/yyyy hh:mm:ss and check?