sql查询日期范围

字符串的日期格式查询日期范围

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'

案例是在别人那你抄的大概自己知道是什么意思了