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
name : date_heure
format : date
values : 2016-01-02 16:20:25.693
name : heure
format : integer
values desired : 16
Thank you for your help. Best regards.
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables