hive算星期几与日期格式化使用

作者官方网站:http://www.wxl568.cn

hive算星期几

select pmod(datediff('2018-06-21', '1920-01-01') - 3, 7)

数据20180705执行后201807

 from_unixtime(unix_timestamp(KQ.INC_day,'yyyyMMdd'),'yyyyMM') 

baruploadtm

string

巴枪上传时间

格式1480535867057

 

 select from_unixtime(cast(substr(barscantm,1,10) as int),'yyyyMMdd') from ods_kafka_fvp.fvp_core_bar_record where inc_day='20180710' limit 10;

 

select from_unixtime(cast(substr(1531271445263,1,10) as int),'yyyyMMdd');

select from_unixtime(cast(1531271445263/1000 as bigint), 'yyyy-MM-dd') ;
select from_unixtime(cast(1531271445263/1000 as bigint), 'yyyyMMdd') ;

from_unixtime(cast(barscantm/1000 as bigint), 'yyyyMMdd') ；

select from_unixtime(unix_timestamp('20181207','yyyyMMdd'),'yyyy/MM/dd') from dual;

select to_date('2018-10-10 10:10:00.000');