日期格式为YYYYmmdd select date_diff(‘day’,date_parse(‘20220103’,‘%Y%m%d’), date_parse(‘20220105’,‘%Y%m%d’)) 日期格式为YYYY-mm-dd select date_diff(‘day’,cast(‘2018-09-05’ as date),cast(‘2018-09-07’ as date));