date format problem in V$logmnr_contents
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: date format problem in V$logmnr_contents

  1. #1
    Join Date
    Nov 2007
    Posts
    10

    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?

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    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
  •  


Click Here to Expand Forum to Full Width