>>Sir I am trying to get maximum date from smalldatetime column
>>For this I am using this command
>>
>>

>>select  max(convert(varchar(10),vou_date,103))as max_date from payments
>>

>>
>>but it is not showing correct date.
>>
>>Please see attachment
>>
>>Thanks
>
>The result it's true. Because 23/06/2017 is max string.
>
>

>select  max(vou_date) as max_date from payments
>

>
>
>MartinaJ

Thanks but the max date is 2017-05-07 as shown in attachment

How to get it?