One Star

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

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
2 REPLIES
Seventeen Stars

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

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

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

How can we do this ?

Thanks,