topic Re: Generate DateTime Records in Talend Studio

Generate DateTime Records

rgranado — Fri, 20 Apr 2018 22:20:59 GMT

Hi,

I need a suggestion on how to generate Datetime Records: HH:mm. In HH24 format or even HH12.

Thanks.

Rhoda

Re: Generate DateTime Records

rgranado — Fri, 20 Apr 2018 23:00:38 GMT

Hi, I found a solution to generate datetime records however, I didn't want to have the seconds just HH:mm. Is there a way to get rid of the ss?

Re: Generate DateTime Records

TRF — Sat, 21 Apr 2018 06:05:52 GMT

Did you try
TalendDate.formatDate("HH:mm", TalendDate.getCurrentDate())

Re: Generate DateTime Records

abhi90 — Sat, 21 Apr 2018 15:25:14 GMT

U can generate any date type using Talenddate.formatdate

Re: Generate DateTime Records

TRF — Sun, 22 Apr 2018 07:49:11 GMT

@rgranado, did this help you?
If so, thank's to mark your case as solved (Kudo also accepted).

Re: Generate DateTime Records

abhi90 — Sun, 22 Apr 2018 07:55:36 GMT

Hi @TRF,
This is not a question posted by me. So cant accept your solution

Re: Generate DateTime Records

rgranado — Wed, 25 Apr 2018 17:09:25 GMT

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.

tmap date functionsdb component DB Typesoutput

There might not be any solution on this component but if you have an alternative I would be gladly to hear it.

Thanks

datetable.PNG

Re: Generate DateTime Records

Anonymous — Thu, 26 Apr 2018 05:20:15 GMT

@ rgranado

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