topic How to convert LDAP Account Expires value into Date format with TIS ? in Talend Studio

How to convert LDAP Account Expires value into Date format with TIS ?

_AnonymousUser — Wed, 26 Jun 2013 16:36:33 GMT

hello,
I 've put Account Expires value from my AD into a varchar field in a sql server 2008 database (ODS)
I don't know how to convert this value to a date format?
Can someone help me ?
thanks in advance,
Christophe
-------------------
TIS 5.1.2
SQL SERVER 2008

Re: How to convert LDAP Account Expires value into Date format with TIS ?

Anonymous — Fri, 28 Jun 2013 05:59:27 GMT

I guess you get this value as String?
In this case use TalendDate.parseDate(pattern, date) routine.

Re: How to convert LDAP Account Expires value into Date format with TIS ?

Anonymous — Thu, 19 Apr 2018 10:43:48 GMT

How can we do this ?

Thanks,