topic Re: Extract Month from Date converting String to Date in Talend Studio

Extract Month from Date converting String to Date

abhi90 — Tue, 16 Jan 2018 14:20:51 GMT

I have a requirement to extract Date which is coming as String in table. I have to convert it to Date in MM/DD/YYYY format and have to extract Month from it. Can anyone suggest what to Do

Re: Extract Month from Date converting String to Date

abhi90 — Tue, 16 Jan 2018 14:27:24 GMT

Hi Shong/TRF/xdshi,

Can you please help

@abhi90 wrote:
I have a requirement to extract Date which is coming as String in table. I have to convert it to Date in MM/DD/YYYY format and have to extract Month from it. Can anyone suggest what to Do

Re: Extract Month from Date converting String to Date

Anonymous — Wed, 17 Jan 2018 07:59:32 GMT

Hello,

You can use convert type in tMap or tConvertType component.

Could you please elaborate your case with an example with input and expected output values? In this way, we can design a demo job for you and post the setting screenshots in this topic.

Thanks for your time.

Best regards

Sabrina

Re: Extract Month from Date converting String to Date

abhi90 — Wed, 17 Jan 2018 09:06:15 GMT

Hi xdshi,

Thanks for your reply. I have data like this 01/07/2017 which is string in Source. Now I want to convert it into Date with MM/DD/YYYY format and want to extract only Month. So Output should I get is 01.

Re: Extract Month from Date converting String to Date

vboppudi — Wed, 17 Jan 2018 22:49:37 GMT

Try the above function.

Regards,

Re: Extract Month from Date converting String to Date

Anonymous — Thu, 18 Jan 2018 07:07:03 GMT

Hello,

If you want to convert String to Date data type. You can use built-in function TalendDate.parse

Please have a look at my screenshots for details.

In addition that yyyy stands for Year, dd stands for day in month(01~31) and DDD stands for Day in year(001~336) in Java.

Best regards

Sabrina