• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] Soustract one hours of a date type input row

#1 2010-03-11 01:53:07

epox_256
Member
Registered: 2010-03-01
Posts: 12

[resolved] Soustract one hours of a date type input row

Tags: [date, sourstract]

Hi guy,
Is the tmap compoment can be used for soustract a fixed value to a date type input row (I mean soustract one hour or one day) ?

I saw somewhere in this forum few posts about talendDate.diff( rowinput.myfiledate, XXX)

How a duration can be manage ?

BTW I will be able to use a tjavaflex component despite I'm not quite sure to fully understand the input/ouput row execution (like the trun component furthermore)

BR
epox

Offline

#2 2010-03-11 03:39:06

shong
Talend team
Registered: 2007-08-29
Posts: 10305
Website

Re: [resolved] Soustract one hours of a date type input row

Hello

Is the tmap compoment can be used for soustract a fixed value to a date type input row (I mean soustract one hour or one day) ?

yes, go to 'repository' -->Code-->Routines-->System and see the routine: TalendDate provided by Talend, it embeds some useful methods for date operation, for example, convert a String to a Date:
TalendDate.parseDate("yyyy-MM-dd HH:mm:ss", 2010-03-11 10:15:10)

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2010-03-11 18:36:15

epox_256
Member
Registered: 2010-03-01
Posts: 12

Re: [resolved] Soustract one hours of a date type input row

Indeed I missed the 'routines repository', I think that I can understand how to use the TalendDate class now ! Thank you very much for your help,
BR
epox

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] Soustract one hours of a date type input row

Board footer

Powered by FluxBB