• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Preceeding zeros are removed

#1 2012-07-06 14:43:47

ilyasiqbal
Member
Registered: 2012-06-04
Posts: 87

Preceeding zeros are removed

Tags: [database, date, mysql]

Hi,

Please check the screenshot where the redlined areas are highlighting the Preceeding zeros of Month, have removed while date conversion.


This is how i'm manipulating it:

String.valueOf(TalendDate.getPartOfDate("YEAR",TalendDate.parseDate("yyyy-MM-dd hh:mm:ss", String.valueOf(row1.timestamp) )) )
+"-"+
String.valueOf(TalendDate.getPartOfDate("MONTH",TalendDate.parseDate("yyyy-MM-dd hh:mm:ss", String.valueOf(row1.timestamp) )) )       



Is that a correct way?


Uploaded Images

Offline

#2 2012-07-06 17:25:12

elcalvomike
Member
Registered: 1970-01-01
Posts: 37

Re: Preceeding zeros are removed

This will only return an integer. If you want the '03' you are going to have to convert to a string and index the part of the date you want using string handling methods.

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Preceeding zeros are removed

Board footer

Powered by FluxBB