hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: from_unixtime() and epoch definition
Date Fri, 31 Oct 2014 12:26:01 GMT
In hive from_unixtime is returned from the timezone which you belong to
"From document : from_unixtime(bigint unixtime[, string format]) : Converts
the number of seconds from unix epoch (1970-01-01 00:00:00 UTC) to a string
representing the timestamp of that moment in the current system time zone
in the format of "1970-01-01 00:00:00".

if possible can you also check by changing the timezone to UTC on your
machine?

On Fri, Oct 31, 2014 at 5:32 PM, Maciek <maciek@sonra.io> wrote:

> meant 1970-01-01 00:00:00 of course…
>
> On Fri, Oct 31, 2014 at 12:00 PM, Maciek <maciek@sonra.io> wrote:
>
>> Any reason why
>>
>> select from_unixtime(0) t0 FROM …
>>
>> gives
>>
>> 1970-01-01 01:00:00
>>
>> ?
>>
>> By all available definitions (epoch, from_unixtime etc..) I would expect
>> it to be 1970-01-01 00:00:00…?
>>
>
>
>
> --
> Kind Regards
> Maciek Kocon
>
>


-- 
Nitin Pawar

Mime
View raw message