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 ! 

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.