I try to find max date from a DATE column, the column format is YYYY-MM and its of type varchar. I tried with the following SQL code: Answer You can try the below way -

SQL Server Convert Varchar to Datetime and Find Max Value

I try to find max date from a DATE column, the column format is YYYY-MM and its of type varchar.

DATE
--------
2020-07     (I try to find this value)
2020-06 
2020-05
2020-04

​x
 
DATE--------2020-07     (I try to find this value)2020-06 2020-052020-04​

I tried with the following SQL code:

SELECT 
    CONVERT(datetime, 'DATE') AS Date 
FROM
    DateTable

 
SELECT     CONVERT(datetime, 'DATE') AS Date FROM    DateTable​

You can try the below way –

select max(cast(concat(columnName,'-01') as date))
from yourtable

 
select max(cast(concat(columnName,'-01') as date))from yourtable​