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

[_AnonymousUser]

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

[Anonymous]

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

[Anonymous]

How can we do this ?

Thanks,