Problem with PARSE DATE

[lcupito]

Hi everyone,

I have a problem to parse a date from millisecond to 'YYYY-MM-DD hh:mm. From tFileProperties i get mtime and i bring it into tmap. How can i trasform this time 1694694720000 into date format YYYY-MM-DD hh:mm? I have mtime_string too but it return Thu Sep 14 14:32:00 CEST 2023 and i can't trasform in my format date. Someone can help me?

thank you

[Fabio_Caimi · Accepted solution]

Hi lcupito,

you can easily get:

• a Date variable from mtime (in this case remember to set the date pattern in the output schema)
• or a String variable from mtime_string.

Depending on what you need, try creating one of these 2 variables in your tMap:

• myDate -> new java.util.Date((long)(row1.mtime*1000)/1000) 
• myString -> TalendDate.formatDate("yyyy-MM-dd HH:mm",TalendDate.parseDate("EEE MMM dd HH:mm:ss zzz yyyy",row3.mtime_string)) 

 

 

Regards,

Fabio