Can you please help
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
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.
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.
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.