Please help me out for this issue to compare Sqlserver:Datetime2 with Oracle:Timestamp in Toad Data Point 4.0.
I ran the sql query in Editor1(SQL Server DB) and Editor2(Oracle DB)
SELECT ANSWER_ID, ANSWER_CAPTION, EFFECTIVE_DATETIME FROM DIM_ANSWER
Data in Data set in Editor1 and Editor2 displays same format for EFFECTIVE_DATETIME as yyyy-MM-dd HH:mm:ss.ffffff.
However, when I tried to compare these two data sets, there are always show different between 2 EFFECTIVE_DATETIME fields.
Status ANSWER_ID ANSWER_CAPTION ANSWER_CAPTION EFFECTIVE_DATETIME EFFECTIVE_DATETIME
Different 0 UNKNOWN NKNOWN 10/13/2014 9:40:04.227 PM 10/13/2014 9:40:04 PM
Setting as follows.
Data Type Formatting:
DateTime Tab : ISO pattern(yyyy-MM-dd HH.mm.ss.ffffff)
Custom Tab : SqlServer:DATETIME2 DateTime yyyy-MM-dd HH.mm.ss.ffffff
If I did it in Toad Data Point 3.6, there are no different at all.
How can this issue be fixed?