当月最后一天转换

hive 

-- HIVE
select
    last_day(
        from_unixtime(
            unix_timestamp('${bizdate}', 'yyyyMMdd')
        )
    ),
    'yyyy-MM-dd'
);

-- PostgreSQL
select (date_trunc('month', '${bizdate}'::date) + interval '1 month' - interval '1 day')::date;
select (date_trunc('month',(stat_dt)::timestamp+'1 months')+'-1 days')::date ;