topic Re: Get hours in 24h from date in Talend Studio

Get hours in 24h from date

Anonymous — Tue, 19 Dec 2017 14:06:59 GMT

Dear experts,

I would get hours from a date with is in this format : '2016-01-02 16:20:25.693'

In my case it's return 4 insted of 16.

In my tmap I've written for my field Heure

Integer.parseInt(routines.TalendDate.formatDate("hh",row2.date_heure))

input

name : date_heure

format : date

values : 2016-01-02 16:20:25.693

output

name : heure

format : integer

values desired : 16

Thank you for your help. Best regards.

TRF — Tue, 19 Dec 2017 21:02:48 GMT

Hi,
Try to replace "hh" by "HH"'
Integer.parseInt(routines.TalendDate.formatDate("HH",row2.date_heure))

Anonymous — Wed, 20 Dec 2017 09:27:23 GMT

Dear TRF, thank you for your help.

Perfect, it's works !