As the previous posters said the column in the table should be kept as datetime and it's a matter of presentation as to how it's displayed.

The following will get your date returned in dd-mm-yy format:

SELECT CONVERT(CHAR(8), yourDateTimeCol, 5) FROM yourTable...

The 5 is a style (see CONVERT function in BOL).