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

select  max(vou_date) as max_date from payments // return max datetime
select  max(CAST(vou_date AS DATE)) as max_date from payments // return max datetime without time - MS SQL 2008>
select  max(CAST(CAST(vou_date AS INT) AS DATETIME)) as max_date from payments // return max datetime without time  <= MS SQL 2005

MartinaJ