topic Re: Convert date to YYYY-MM-dd.. in Talend Studio

Convert date to YYYY-MM-dd..

Anonymous — Sat, 16 Nov 2024 04:22:13 GMT

Hi All.

How to convert Tue Oct 15 00:00:00 SGT 2019 to YYYY-MM-dd format? Thanks in advance

Re: Convert date to YYYY-MM-dd..

Anonymous — Wed, 16 Oct 2019 10:58:09 GMT

This depends on what you are doing. If your column is a Date object and you are printing out to the terminal or to a flat file, then you just need to deal with the format on the schema. If you are have a String representation of a date coming in and want to change it, you will need to parse it as a date and then format the output. What exactly are you trying to do here?

Re: Convert date to YYYY-MM-dd..

Anonymous — Wed, 16 Oct 2019 21:57:07 GMT

Hi,

If your input data is a String, you can convert to date as shown below

Relational.ISNULL(row1.input_date)?null:TalendDate.parseDate("E MMM dd HH:mm:ss Z yyyy",row1.input_date)

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Convert date to YYYY-MM-dd..

Anonymous — Thu, 17 Oct 2019 04:23:08 GMT

Dear @nthampi,

My issue is resolved. Thank you so much for your help 🙏 🙏

Re: Convert date to YYYY-MM-dd..

Anonymous — Thu, 14 Nov 2019 03:12:39 GMT

Dear @nthampi ,

Is it possible if I want to convert from "Tue Oct 15 00:00:00 SGT 2019" to YYYY-MM-DD hh:mm:ss.sss format? Kindly advice. Thank you

Re: Convert date to YYYY-MM-dd..

Anonymous — Thu, 14 Nov 2019 03:33:28 GMT

Hi
You just need to change the data pattern of column 'output_date' on tMap to "yyyy-MM-dd HH:mm:ss.SSS"

Regards
Shong