记录板

昨天：select mid,join_time from b_dwd.dwd_prty_memb_basic_base_info_a_d

where substr(format_datetime(cast(join_time),'yyyy-MM-dd') ,1,10) = format_datetime(cast(now() - interval '1' day as date),'yyyy-MM-dd') 

 

select * from b_dwd.dwd_prty_memb_basic_base_info_a_d where join_time = current_date - interval '1' day limit 10;

 

select count(mid) from b_dwd.dwd_prty_memb_basic_base_info_a_d where position()

字符串类型日期

SELECT format_datetime(cast(now() - interval '1' day as date),'yyyy-MM-dd') 

字符串包含

select substr('1599319787151',1,4)   左右都是闭