Data Compare synchronization script does not include timestamp of Date fields. (4226028)

Data Compare is used on tables Date datatype columns having Timestamp values. However, the synchronization wizard script does not include Timestamp values in the table Update statement and hence this information is not updated in the target tables.

Synch wizard does not include TIME format parameter inside the TO_DATE function as such:

UPDATE "SCOTT"."EMP" SET "HIREDATE" = TO_DATE('08.22.2011', 'MM/DD/YYYY') WHERE "EMPNO" = 2;

Which should be:

UPDATE "SCOTT"."EMP" SET "HIREDATE" = TO_DATE('08.22.2011 02:55:44 ', 'MM/DD/YYYY HH24:MI:SS') WHERE "EMPNO" = 2;

WORKAROUND:
None

Issue is fixed in the latest beta release at: http://tda.inside.quest.com/beta.jspa