Datetime field

Hello,

I need to show only the date and not the date and time in a datetime field. How do I do this ? EG only store date not date and time.

I want to do this via enterprise manager

Many thanks

GrantEnterprise manager will show you the whole thing by default. making a view with an appropriate CAST operation in it might help you - does this sound like the kind of thing you're after?|||print convert(varchar(10), getdate(), 103)

Look up CONVERT in BOL for other formats. Cast sucks on dates.