The best ways is keep date column datatype as datetime and whenever you want to retrieve data from database then you can fetch in different format for ex. you can also try some other no. also
SELECT convert(varchar, getdate(), 103)<pre lang="sql">
SELECT convert(varchar, getdate(), 105)
SELECT convert(varchar, getdate(), 109)