topic Re: Parse Date in Talend Studio

Parse Date

Fernandez — Mon, 17 May 2021 20:45:06 GMT

Hi,

I have to modify the date format of a tag in a xml file.

The date is in format : 03/05/2021 7:00:00 PM

and I want to get it in format :

03/05/2021

19:00:00

I try with parseDate, parseDateLocale, formatDate... and I did'nt succeed.

Thanks for your help

Re: Parse Date

Anonymous — Tue, 18 May 2021 01:08:41 GMT

What's data type of this column? Assuming it is date type, change its date pattern to "dd/MM/yyyy HH:mm:ss" on the schema.

Regards

Shong

Re: Parse Date

Fernandez — Tue, 18 May 2021 19:20:01 GMT

Hi,

It doesn't work, the format doesn't change.

Below the screenshots:

Thanks for your help !

Re: Parse Date

Anonymous — Wed, 19 May 2021 01:30:26 GMT

I think this is a date display format issue in target Oracle DB, if you print the data on the console, you will see that the data display as you expected, you can change the date display format in DB, please refer to Oracle documentation.

Regards

Shong

Re: Parse Date

Fernandez — Wed, 19 May 2021 07:54:16 GMT

Hi,

With console, it's the same...

Xml input

Mapping

Result

Re: Parse Date

gjeremy1617088143 — Wed, 19 May 2021 09:20:00 GMT

Hi, just use HH instead of hh for hours in the output date pattern.

I just try it in a tjavarow and it works :

input : 03/05/2021 7:00:00 PM

output : 2021-05-03 19:00:00

Send me Love and Kudos

Re: Parse Date

Anonymous — Wed, 19 May 2021 10:07:56 GMT

hh: hour in AM/PM (01-12), HH: hour in day (00-23), as @guenneguez jeremy suggested, change hh to HH.

Re: Parse Date

Fernandez — Fri, 21 May 2021 13:27:46 GMT

Hi,

It also doesn't work with HH...

Re: Parse Date

gjeremy1617088143 — Fri, 21 May 2021 13:47:20 GMT

can you try it on a tjavarow instead of TMap, you are on open studio : maybe TMap date pattern have a bug, if you have the same issue with tJavarow maybe all date pattern have a bug in your version of open studio. Sometime there is cache issue with tmap you have to delete it and make a new one.

Re: Parse Date

Anonymous — Sat, 22 May 2021 00:45:35 GMT

Change the date pattern of input data to "dd/MM/yyyy hh:mm:ss aa". Please try again.

Regards

Shong