title: How to do date date comparison in Amazon Athena , Here my date columns are in string in the (yyyy-mm-dd) format
body: <p>How  to do date comparison in amazon Athena ?- I am using the following query but ,it is not working - date(dt) between date('2020-01-01') and date('2020-01-31'). Please note here 'dt' is an string column.</p>