Thursday, July 16, 2015

Talend Date Functions

Here are some Talend useful functions...

1. TalendDate.getPartOfDate("DAY_OF_MONTH","2015-12-29");
Output: 29
Note: input date shuld be in date datatype.

2. TalendDate.getLastDayOfMonth("2015-12-13");
Output: 2015-12-31

3.TalendDate.getFirstDayOfMonth("2015-12-13");
Output: 2015-12-01

4. TalendDate.getCurrentDate();
Output: return current date in date datatype.

5. TalendDate.parseDate("yyyy-MM-dd HH:mm:ss","2015-12-23 15:12:11");
Output: Wed Dec 23 15:12:11 IST 2015 (in date datatype).

No comments:

Post a Comment