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 <mac...@sonra.io> wrote: > meant 1970-01-01 00:00:00 of course… > > On Fri, Oct 31, 2014 at 12:00 PM, Maciek <mac...@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