Toad World® Forums

Sync Target with Source Date Format

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?

Toad for Oracle Base

vers. 11.6.1.6

DB Admin Module

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