hive_查询整理

Select from_unixtime(cast(cast(time as bigint) / 1000 as BIGINT) )

select from_unixtime(unix_timestamp(),'yyyy-MM-dd HH:mm:ss')

select to_date()

select date_add(string startdate, int days)