[resolved] Convert data type string to time

[Anonymous]

Hi all,
I'm having real problem to upload one table of the db, online. I have a 'time' field in my table (initialy 'Time' database type and 'Date' type in tMap), which i read in tMap as a string and i want to convert it to time in the output. I have used these to methods
//TalendDate.formatDate("HH:mm:ss",row1.ora);
//TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",row1.ora);
..but none of them worked. What should i do? If you need more information just tell me, please! It's the first time i write here so i may be uncomplete..
P.S: The reason i run through this solution is because i couldn't export the 'ora' column as it's initial type. It always showed me the error pictured in pic a5.
Thanks in advance!

[Anonymous · Accepted solution]

Hi
Try this expression

TalendDate.parseDate("HH:mm:ss",row1.ora)

[Anonymous]

It worked!!! Thank you very much!! ))