I need a suggestion on how to generate Datetime Records: HH:mm. In HH24 format or even HH12.
Solved! Go to Solution.
sorry I couldn't reply so quickly.
I have done those changes and I am familiar with those functions. I believe the format is dictated by the database component.
There might not be any solution on this component but if you have an alternative I would be gladly to hear it.
Talend appears to be processing as required. That is the database query is showing 12:00:00. The problem is most likely the database itself and the default configurations it has in displaying the various data types. Check the query tool you are using and the default settings it has for displaying the time data type. If you require the database to save the time in a specific format you may need to look at a char field
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.