Salesforce Date pattern to "dd-mm-yyyy" for talend mysql
HoAt the moment I have configured salesforce input and database output, and mapped them together.
I have a column in mysql database which stores "LastModifiedDate". In talend mapping the format for this is "dd-mm-yyyy". When I run the job, this column is always null in the database. It must be because the salesforce format is different- how can I fix this in talend?
Please help, I am very new to talend so screenshots would be appreciated. I saw other posts like this but without clear answers. I am not sure where to even try parsing it..
mm is minutes. MM is months. in Talend its all about java date formats, so "dd-MM-yyyy"
So if you define columns in Talend, Java it is, components will automatically map it for you , some types you need to map yourself... mostly involvesd when working with bytes or specific primary (auto db) key.
It is all pretty straightforward. Date formats vs DateTime formats in databases are just all date formats in Java...but make sure you use the right format specs: Java Date formats
