topic Re: [resolved] Convert 12 Hour Format Date to 24 Hour Date Format in Talend Studio

[resolved] Convert 12 Hour Format Date to 24 Hour Date Format

Anonymous — Tue, 15 Dec 2015 19:36:33 GMT

Hi -
I would like to convert add hours to a 12 Hour Format date so that it goes to next day when required. However by using the TalednDate.addDate fuction in my tMap as follows, its still not going to next day when required and just ading the hours in 24 hours format). Can you please let me know if I am missing something?

Source: "2015-12-10 11:08:00.003 PM"
tmap: TalendDate.addDate(TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",row1.mydatetime) ,4,"HH")

Current Output: "2015-12-10 17:08:00"
Expected output: "2015-12-11 05:08:00 AM"

Re: [resolved] Convert 12 Hour Format Date to 24 Hour Date Format

Anonymous — Wed, 16 Dec 2015 03:38:56 GMT

Try this expression:

TalendDate.addDate(TalendDate.parseDate("yyyy-MM-dd hh:mm:ss.SSS aa",row1.mydatetime) ,4,"HH")

Re: [resolved] Convert 12 Hour Format Date to 24 Hour Date Format

Anonymous — Wed, 16 Dec 2015 05:01:01 GMT

Hi,

I tried the same but this error came..

Exception in component tRowGenerator_1

may i know why?

Re: [resolved] Convert 12 Hour Format Date to 24 Hour Date Format

Anonymous — Wed, 16 Dec 2015 08:35:35 GMT

Hi
The error occurs on tRowGenerator, please upload some screenshots of the component settings and provide external informations, so that we can continue to help you.

Re: [resolved] Convert 12 Hour Format Date to 24 Hour Date Format

Anonymous — Tue, 29 Dec 2015 14:50:03 GMT

Thanks a lot shong that works.