[thelist] changing default date in sql server

Peter Brunone (EasyListBox.com) peter at easylistbox.com
Thu Jun 23 00:58:56 CDT 2005

	You just want it formatted when you select it, correct?

SELECT CONVERT(varchar(10), myDateValue, 101)



-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of 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?


More information about the thelist mailing list