-
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?
-
This should explain it for ya..Overview of DATE Datatype.
Why would you NOT want to store a DATE as a DATE ??
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|