date format problem in V$logmnr_contents
Hello,
I run the following insert statement. The table structure is
id number
dt date
insert into newtab1 values(2,'10-JUN-07');
When I mine it from v$logmnr_contents I get the above statement as
insert into "SCOTT"."NEWTAB1"("ID","DT") values (2,TO_DATE('10-JUN-2007 00:00:00', 'DD-MON-YYYY HH24:MI:SS'));
I dont understand why the TO_DATE conversion comes here. Is there any way to get the insert statement from v$logmnr_contents with out the date conversion function?