Hive Day03.2~日期函数

函数

首先为了测试函数，我们先随便建一张表
hive> create table dual(id string);
hive> insert into table dual values(1);

例如：要测试函数substr怎么使用
hive> select substr(“abcd”,0,2) from dual;

日期函数

hive> select current_date from dual;

hive> select current_timestamp from dual;

hive> select unix_timestamp() from dual;

hive> select unix_timestamp(‘2019-05-07 13:01:03’) from dual;

hive> select unix_timestamp(‘20190507 13:01:03’,‘yyyyMMdd HH:mm:ss’) from dual;

hive> select from_unixtime(1557205263,‘yyyy-MM-dd HH:mm:ss’) from dual;

获取日期、时间

hive> select year(‘2011-12-08 10:03:01’) from dual;

hive> select year(‘2012-12-08’) from dual;

hive>select month(‘2011-12-08 10:03:01’) from dual;

hive>select day(‘2011-12-08 10:03:01’) from dual;

hive>select hour(‘2011-12-08 10:03:01’) from dual;

hive>select minute(‘2011-12-08 10:03:01’) from dual;

hive>select second(‘2011-12-08 10:03:01’) from dual;

日期增减

hive>select date_add(‘2012-12-08’,10) from dual;

hive>select date_sub(‘2012-12-08’,10) from dual;