https://community.qlik.com/t5/Talend-Studio/How-to-convert-date-from-CRM/m-p/2302022#M74056 set the date format in talend like: "yyyy-MM-dd'T'HH:mm:ss'Z'"<BR />The sql output component will do the rest. Fri, 10 Aug 2018 21:46:58 GMT Jesperrekuh 2018-08-10T21:46:58Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-date-from-CRM/m-p/2302021#M74055 <P>My source is CRM and the date is coming like this&nbsp;2004-06-20T05:00:00Z.</P><P>How do we load to sql server with datetime datatype?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 10 Aug 2018 19:18:11 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-date-from-CRM/m-p/2302021#M74055 rp2018 2018-08-10T19:18:11Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-date-from-CRM/m-p/2302022#M74056 set the date format in talend like: "yyyy-MM-dd'T'HH:mm:ss'Z'"<BR />The sql output component will do the rest. Fri, 10 Aug 2018 21:46:58 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-date-from-CRM/m-p/2302022#M74056 Jesperrekuh 2018-08-10T21:46:58Z