Yeah, it will not , the expression should be in
datetime
format to convert.
it will work,because
getdate()
is
Datetime
.
select convert(varchar(14),Getdate() ,106)
So, please convert your
Date
format into
Datetime
Format before you proceed.
select convert(varchar(14),convert(datetime,'29/05/2014',103) ,106)