Six Stars

Get hours in 24h from date

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars TRF
Twelve Stars

Re: Get hours in 24h from date

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

TRF
2 REPLIES
Twelve Stars TRF
Twelve Stars

Re: Get hours in 24h from date

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

TRF
Six Stars

Re: Get hours in 24h from date

Dear TRF, thank you for your help. 

 

 

Perfect, it's works !