字符串的日期格式查询日期范围
SELECT *, CONVERT ( VARCHAR, DATE_col, 101 ) AS DATE_col_date FROM DW.table_name WHERE DATE_col_date BETWEEN '2020-01-06' AND '2020-31-12'
案例是在别人那你抄的大概自己知道是什么意思了