Date issue

[BA621858188]

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

[Anonymous · Accepted solution]

Hi

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