Four Stars

How to convert date from CRM?

My source is CRM and the date is coming like this 2004-06-20T05:00:00Z.

How do we load to sql server with datetime datatype?

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Nine Stars

Re: How to convert date from CRM?

set the date format in talend like: "yyyy-MM-dd'T'HH:mm:ss'Z'"
The sql output component will do the rest.
1 REPLY
Nine Stars

Re: How to convert date from CRM?

set the date format in talend like: "yyyy-MM-dd'T'HH:mm:ss'Z'"
The sql output component will do the rest.