作者官方网站: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');