[thelist] changing default date in sql server

[Andrew Martin]

Is there a way to not have sql server strip the 0 from a date such as:
04/04/2005?
I could store the date as text instead of datetime but that just seems
wrong.  Any ideas?

Thanks