Get hours in 24h from date

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.


Accepted Solutions
Forteen Stars TRF
Forteen 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

All Replies
Forteen Stars TRF
Forteen 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 !