Date issue

BA621858188 — Mon, 08 Aug 2022 10:41:54 GMT

Hi All,

I am facing date conversion issue in my job.

create table table1

( id int,

loaddate date)

select id,

max(date_format(loaddate,'%Y-%m-%d'))

from table1 -- used below query in tmysqlinput but getting date as

1 2022-07-30 00:00:00.0

using tjavarow I am printing it still I am getting the date in

2022-07-30 00:00:00.0 format.

can anyone tell me the reason? I am using Talend 7.2.1 version.

Also, I need to store this date in the context and If I create context as date datatype then how can I convert the date in the javarow component in the yyyy-mm-dd format.

Thanks in advance

Re: Date issue

Anonymous — Mon, 15 Aug 2022 03:33:30 GMT

select the date column directly from table without using the function date_format(), and set the date pattern as "yyyy-MM-dd" of date column on the schema,

"select id,

max(loaddate)

from table1"

Regards

Shong

topic Re: Date issue in Talend Studio

Date issue

Re: Date issue