topic Re: Inserting only TIME into Table in Talend Studio

Inserting only TIME into Table

lungm — Thu, 06 Mar 2014 15:28:50 GMT

I am trying to insert a DATE formatted as "HH:mm:ss" into a Netezza Table as a TIME formatted as "HH:mm:ss". I am able to parse and format the time correctly but when I go to insert it into the table I receive the following error:
ERROR: Bad time external representation '1970-01-01 13:59:29.0'
But when I view it from a tLogRow it shows up in the correct format of 13:59:29 PM . What is causing this issue?
Talend Platform for Data Management,
Version: 5.3.1
Build id: r104014

Re: Inserting only TIME into Table

bkar81 — Thu, 06 Mar 2014 18:14:22 GMT

Please check the output date pattern in Netezza output component. If the date pattern is different, then this might cause this error.
Try using a delimited file output and check. Since there is no date, it is taking default date as 1/1/1970 with time and trying to insert it into a time field.

Re: Inserting only TIME into Table

Anonymous — Fri, 07 Mar 2014 17:11:47 GMT

Talend cannot hold only time. It will always hold the value as datetime. Even if the date format is specified to be HH:mm:ss it is still a datetime object and will contain a date. The solution would be to convert the datetime stamp into a String containing only the time.
Inside your Database output component change the talend type "Type" from DATE to String but keep the "DB Type" as TIME.