Hi.
I want use ‘compare data’ tool
But “Sync Target with Source” buttons is not work correctly
insert scripts date format is not correct
tools do
_INSERT INTO XXX.XXXXXX (MODIFIED_TS) VALUES (12/05/2010 15:23:21);
tools must be
_INSERT INTO XXX.XXXXXX (MODIFIED_TS) VALUES (TO_TIMESTAMP(‘12/05/2010 15:23:21’,‘DD/MM/YYYY HH24:MI:SS’));
how can i change date format in tools insert scripts
Hi,
Which product is this referencing?
Thank you. I’m moving this thread to the appropriate forum.
I just checked the source code for 11.6, and I see that we are specifying timestamps as you would like, using to_timestamp(). I am not sure why you don’t see them. Can you give me the DDL for the tables that you are comparing and insert statements for a few rows?
how can i change date format in tools insert scripts
IMHO, you are making some kind of custom nls_date_format calls.
What does
select sysdate from dual;
produces.
Please make an output when Ctrl+Enter is pressed (plain SQL) as well as F5 (script).
What happened if you run previous SQL directly in sqlPlus (oracle)?
Brg,
Damir Vadas