Re: String to specific date format conversion in Wrangler Data fusion GCP

[Albert Shau]

Hi,

In wrangler you can click on the parse menu, which will have an option to parse as a simple date. This has several pre-defined formats available, or you can specify your own. Note that this will create a CDAP 'timestamp' type, since the 'date' type only has year, month, and day.

Regards,

Albert

On Sun, Oct 20, 2019 at 11:24 PM <darpa...@gmail.com> wrote:

I have found you on google community about technical discussion. 

I have issues in my date fusion. 

I have string in the format of 'yyyy-MM-dd HH:mm:ss' format.

During transformation or in Wrangler, I wanted to convert into date format with 'yyyy-MM-dd HH:mm:ss' format.

Can you please help on it. 

Thanks in advance.

--
You received this message because you are subscribed to the Google Groups "CDAP User" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cdap-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/cdap-user/96fce1f2-d9fe-47d9-a839-9c7f965078a9%40googlegroups.com.

[shahd...@gmail.com]

HI,

I have already tried this but along with that timezone is coming like UTC or PST.

Any other solution to get yyyy-MM-dd HH:mm:ss format.

Thanks.

On Monday, October 21, 2019 at 10:28:22 PM UTC+5:30, Albert Shau wrote:

Hi,

In wrangler you can click on the parse menu, which will have an option to parse as a simple date. This has several pre-defined formats available, or you can specify your own. Note that this will create a CDAP 'timestamp' type, since the 'date' type only has year, month, and day.

Regards,

Albert

On Sun, Oct 20, 2019 at 11:24 PM <darpa...@gmail.com> wrote:

I have found you on google community about technical discussion. 

I have issues in my date fusion. 

I have string in the format of 'yyyy-MM-dd HH:mm:ss' format.

During transformation or in Wrangler, I wanted to convert into date format with 'yyyy-MM-dd HH:mm:ss' format.

Can you please help on it. 

Thanks in advance.

--
You received this message because you are subscribed to the Google Groups "CDAP User" group.

To unsubscribe from this group and stop receiving emails from it, send an email to cdap...@googlegroups.com.

[Albert Shau]

That is how a timestamp is displayed in wrangler. It is not a string anymore.

To unsubscribe from this group and stop receiving emails from it, send an email to cdap-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/cdap-user/fae3199b-6c85-4c90-aaa9-d56739e7c24f%40googlegroups.com.