How to subtract a date in a column with one day ?

[prabuj]

Dear Team, @Xiaodi Shi @Shicong Hong @TRF

Could you please help out to solve this requirement ? I would like to subtract a day from a date column.

DATE -1

For ex:

INPUT

1992-04-26 15:03:22

REQUIRED OUTPUT:

1992-04-25 15:03:22

Thanks in advance.

[dilip_n · Accepted solution]

Hi there,

you can use "add date" function in tmap.

In tMap use like this :- TalendDate.addDate(date_column,-1,"dd").

Here if you use "-1" as "days" and it will subtract date. do this and try it.