Re: Extracting data from ELB log date format

[Manish Rangari]

Thanks Nichole and Dudu for the reply. I got what I was looking for.

--Manish

On Thu, Sep 22, 2016 at 2:52 AM, Markovitz, Dudu 
wrote:

> select to_date(ts),year(ts),month(ts),day(ts),hour(ts),minute(ts),second(ts)
> from (select from_unixtime (unix_timestamp 
> ('2016-09-15T23:45:22.943762Z',"-MM-dd'T'HH:mm:ss"))
> as ts) as t;
>
> OK
>
> 2016-09-15 2016 915   23   45   22
>
>
>
> Dudu
>
>
>
> *From:* Manish Rangari [mailto:linuxtricksfordev...@gmail.com]
> *Sent:* Wednesday, September 21, 2016 4:23 PM
> *To:* user@hive.apache.org
> *Subject:* Extracting data from ELB log date format
>
>
>
> Guys,
>
>
>
> I am trying to extract date, time, month, minute etc from below timestamp
> format but did not find any function for this. Can anyone help me to
> extract the details?
>
>
>
> 2016-09-15T23:45:22.943762Z
>
> 2016-09-15T23:45:22.948829Z
>
>
>
> --Manish
>

RE: Extracting data from ELB log date format

[Markovitz, Dudu]

select to_date(ts),year(ts),month(ts),day(ts),hour(ts),minute(ts),second(ts) 
from (select from_unixtime (unix_timestamp 
('2016-09-15T23:45:22.943762Z',"-MM-dd'T'HH:mm:ss")) as ts) as t;
OK
2016-09-15 2016 915   23   45   22

Dudu

From: Manish Rangari [mailto:linuxtricksfordev...@gmail.com]
Sent: Wednesday, September 21, 2016 4:23 PM
To: user@hive.apache.org
Subject: Extracting data from ELB log date format

Guys,

I am trying to extract date, time, month, minute etc from below timestamp 
format but did not find any function for this. Can anyone help me to extract 
the details?

2016-09-15T23:45:22.943762Z
2016-09-15T23:45:22.948829Z

--Manish