DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007

    date format problem in V$logmnr_contents

    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
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.