topic Re: Adding 1 minute in the parm file in Talend Studio

Adding 1 minute in the parm file

mani1304 — Sat, 16 Nov 2024 04:34:45 GMT

Hi All,

I need to add 1 min to the parm file's end date and assign this time to FILE_NAME_TIME_STAMP context fieldname(which is string) and I am using TalendDate.addDate function for date and this is working fine for all times except for 12:29 and 12:59, Ideally it should make the date to 12:30 and 13:00, instead of this, date is modifying to 00:30 and 01:00, can somebody suggest on this and how to get the desired output.

TalendDate.formatDate("yyyyMMdd_HHmm",TalendDate.addDate(row1.end_dttm,1,"mm"))

Re: Adding 1 minute in the parm file

fdenis — Wed, 25 Sep 2019 08:16:31 GMT

check format of row1.end_dttm it may be set to 12 hour format
is row1.end_dttm a string?
if yes convert it first using TalendDate.parseDate(“yyyy-MM-dd’T’HH:mm:ss.SSS”, row1.end_dttm)

Re: Adding 1 minute in the parm file

mani1304 — Wed, 25 Sep 2019 09:27:17 GMT

Spoiler

Thanks, it was hhmm there.