date format problem in V$logmnr_contents
I run the following insert statement. The table structure is
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?
This should explain it for ya..Overview of DATE Datatype.
Why would you NOT want to store a DATE as a DATE ??
Click Here to Expand Forum to Full Width