inconsistant date formats in DML error logging tables

User_ZEGP5

I have used DML error logging tables in my project and i am facing problem with date datatype column being stored in the ERR$_ tables.

datatype of date field in Error log table in VARCHAR2(4000), which is created by itself on using DBMS_ERRLOG.create_error_log method.

few tables have the data in in DD-MON-RR format and others are in YYYY.MM.DD HH24:MI:SS

Please suggest on this.

jaramill

This is the WRONG forum for this question.  This for people to talk about their profile/resume/experience after achieving the Oracle Master certification for Oracle DBA version 12c.

OP (Original Poster) or Moderators please move this question to the --> forum.