Viewing 2 posts - 1 through 2 (of 2 total)
varchar(10) means upto 10 only
while
varchar()mean varchar(max) so it gives u timeformat also !
now got it !
February 17, 2012 at 3:21 am
#1448374
CONVERT(datetime, '2006-04-25T15:50:59.997', 131)
SELECT convert(varchar, getdate(), 111
)
http://msdn.microsoft.com/en-us/library/ms187928.aspx
any queries please post !
February 17, 2012 at 2:40 am
#1448342