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',"yy
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.co
in Hive CL:
set today = cast(concat(substr(cast(current_date() as
string),1,4),substr(cast(current_date() as
string),6,2),substr(cast(current_date() as string),9,2)) as int)
From: Manish Rangari
Reply-To: "user@hive.apache.org"
Date: Wednesday, September 21, 2016 at 6:23 AM
To: "user@hive.apa