>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

select  max(vou_date) as max_date from payments

PS: I don't know why but when I saw your question, I didn't see that Martina already replied.