Forum Stats

  • 3,826,759 Users
  • 2,260,705 Discussions


inconsistant date formats in DML error logging tables

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
    jaramill Member Posts: 4,299 Gold Trophy
    edited Aug 14, 2020 8:15PM

    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.