tMap join - inner join -on- "Date" type !!

One Star

tMap join - inner join -on- "Date" type !!

simple inner join with 2 conditions.  How can I achieve this using TMap?
SELECT *
    FROM Table1 t1
    JOIN Table2 t2
    ON t2.col3 = t1.col7  AND t1.col2 = t2.col14
I am attaching the screenshots.
When I run the query in MySQL, it returns 178 rows whereas with my TMap, it returns 0 rows. 
The problem is "comparing dates for join".  t2.col3 and t1.col7 type "Date"
When I try to inner join on columns of Date type, I could not.
Another problem is my in MYSQL the columns is DateTime format(2015-04-07 10:38:52 10:38:52), but after mapping to the targettable,  I get only datepart(2015-04-07) in target table.  I tried changing the date type in datetime format ,  nothing works out Smiley Sad
Please someone help me to figure out.
Community Manager

Re: tMap join - inner join -on- "Date" type !!

Hi 
By default, the date pattern of Date type is "dd-MM-yyyy", you need to change the date pattern to "yyyy-MM-dd HH:mm:ss" if you want to read & output timestamp. 
Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download