>>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?