topic Re: [resolved] HOW TO GET HOUR IN PM FORMAT in Talend Studio

[resolved] HOW TO GET HOUR IN PM FORMAT

Anonymous — Mon, 09 May 2016 13:58:06 GMT

Morning All,
I try to get hour in PM Format from my date column.
I use this expression in my tMap:

TalendDate.getPartOfDate("HOUR",row1.Date_debut_Formation)

And my date column format look like this: "dd/MM/yyyy HH:mm"
Exemple of data (Input)
14/04/2016 09:00:00
06/04/2016 10:00:00
14/04/2016 17:00:00
27/05/2016 18:00:00
Result (Output)
9
10
5
6
May somebody explain me why i don't get PM value ?
Because for me, result should be: 9 , 10, 17, 18

Thanks,

Re: [resolved] HOW TO GET HOUR IN PM FORMAT

Anonymous — Mon, 09 May 2016 14:16:22 GMT

Unfortunately, this is a limitation with the Talend method, as it does not support HOUR_OF_DAY (24 hour clock).
Someone may know an elegant Talend way of doing this, otherwise you'll need to do it yourself with your own Java routine.

Re: [resolved] HOW TO GET HOUR IN PM FORMAT

Anonymous — Mon, 09 May 2016 15:10:42 GMT

OK Thanks tal00000

Re: [resolved] HOW TO GET HOUR IN PM FORMAT

Anonymous — Thu, 09 Mar 2017 16:00:06 GMT

Hello,

I find solution to this problem on this link: https://community.talend.com/t5/Design-and-Development/Date-and-Time-Format-With-HH24/m-p/65183
You need to edit TalendDate routine file by adding DAY_OF_WEEK parameter.

Thanks,