You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@pig.apache.org by Mix Nin <pi...@gmail.com> on 2013/03/18 21:24:59 UTC

Extract Date part from ISO datetime format

How to get only Date part from ISOFROMAT

I have input as below

2013-03-10T08:00:24.338Z

How do I get output as 2013-03-10

Re: Extract Date part from ISO datetime format

Posted by Mason <ma...@verbasoftware.com>.

There might be an easier way, but I bet you could whip up a solution with
the helpers in Piggybank:
http://svn.apache.org/viewvc/pig/trunk/contrib/piggybank/java/src/main/java/org/apache/pig/piggybank/evaluation/datetime/
.

On Mon, Mar 18, 2013 at 1:24 PM, Mix Nin <pi...@gmail.com> wrote:

> How to get only Date part from ISOFROMAT
>
> I have input as below
>
> 2013-03-10T08:00:24.338Z
>
> How do I get output as 2013-03-10
>