Flashback Transaction Query and date datatypes [message #331942] |
Sun, 06 July 2008 15:53  |
bpeasey
Messages: 46 Registered: March 2005
|
Member |
|
|
Hi,
I've been testing out the Flashback Transaction Query and noticed a problem. In the undo_sql column with inserts, date data type is missing the hours, minutes and seconds values.
select undo_sql from flashback_transaction_query where table_owner = 'SCOTT' and operation = 'DELETE'
UNDO_SQL
insert into "SCOTT"."TEST"("TEST_ID","DTM") values ('2500',TO_DATE('06-JUL-08', 'DD-MON-RR'));
insert into "SCOTT"."TEST"("TEST_ID","DTM") values ('2499',TO_DATE('06-JUL-08', 'DD-MON-RR'));
insert into "SCOTT"."TEST"("TEST_ID","DTM") values ('2501',TO_DATE('06-JUL-08', 'DD-MON-RR'));
The DTM column was originally populated with sysdate, and existing data contains hours, minutes and seconds values.
select * from scott.test where rownum < 4
TEST_ID DTM
4 10/06/2008 1:35:14 PM
17 10/06/2008 4:50:11 PM
18 10/06/2008 5:05:13 PM
Is there a step I've missed, or is it something I need just be aware of if I used this feature in the future?
Best regards,
Brian
|
|
|
|
|
|