BIGINT - STRING DATE FORMAT

Anonymous — Tue, 22 Mar 2016 20:26:38 GMT

one of the column in my MySQL db table is
"job_UTC_Time" "BIGIINT" datatype - length 20
UTC_Time is in milliseconds. for example: 1451427036333

By using the tMySQLInput, I need to qurey all the columns includting job_UTC_time.

The query should also include the where condition.
where job_UTC_Time >= context.start_date and job_UTC_Time <= context.enddate

context variables are defined as string and default vale is set as '2015-01-01 00:00:00' (start_date) and '2016-03-09 00:00:00' (enddate)

How can I compare BIGINT which hold data in milliseconds with start_date which is string?
I could not attach screenshots as this forum throws errors :The server was unable to save the uploaded file.

Re: BIGINT - STRING DATE FORMAT

Anonymous — Fri, 08 Apr 2016 04:48:42 GMT

Hi
Convert the string value to a Date, and get the millseconds using the method getTime(), try this:

"....where job_UTC_Time>="+(TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",context.[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] start_date)).getTime()+" and job_UTC_Time <="+[/font][/color](TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",context.enddate)).getTime()

Regards
Shong

topic Re: BIGINT - STRING DATE FORMAT in Talend Studio

BIGINT - STRING DATE FORMAT

Re: BIGINT - STRING DATE FORMAT