topic Re: Date format pattern in Talend Studio

Date format pattern

RA6 — Fri, 15 Nov 2024 22:52:08 GMT

Hello guys,

Can someone knows the date format for the below example:

2022-02-14 09:55:36.049 +0100

The sql ddl of this field is "DATE_INSERTION TIMESTAMP_LTZ(9)," in the database.

I have tried the below solution but it is not working:

Pattern: "yyyy-MM-dd HH:mm:ssXXX"

2022-02-14 12:55:36.049+04:00

+ the output in bold is not good too.

Can someone help please?

Thank you.

Best regards,

Re: Date format pattern

Anonymous — Thu, 02 Jun 2022 08:18:27 GMT

Try this

"yyyy-MM-dd HH:mm:ss.SSSXXX"

Regards

Shong

Re: Date format pattern

SMR040 — Thu, 02 Jun 2022 09:47:30 GMT

Also check the documentation on what kind of patterns there are:

https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

Re: Date format pattern

RA6 — Fri, 03 Jun 2022 07:01:44 GMT

@Shicong Hong

Hello Shong,

I have tried the two format below, the date pattern are OK.

They are both giving me the same result:

"yyyy-MM-dd HH:mm:ss.SSS XX"

"yyyy-MM-dd HH:mm:ss.SSS Z"

Result:

2022-02-14 12:55:36.049 +0400

But what bothers me, the is two highlighted "12" and "04", beacause my input date is:

2022-02-14 09:55:36.049 +0100

Can you advice please?

Thank you.

Best regards,

Re: Date format pattern

gjeremy1617088143 — Fri, 03 Jun 2022 08:10:36 GMT

Hi @Rohit Aftab maybe your issue come from to different Timezone between the server of your db and your etl server. in the DB you have a LTZ format for local time zone.