How to convert date from CRM?

[rp2018]

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?

[Jesperrekuh · Accepted solution]

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