• Try something like this:

    select CONVERT(date, mydate, 103)

    from mytable