using smalldatetime to ONLY store date

microsoft.public.dotnet.framework.adonet

13 Jan 2006 12:50 AM

Brian Mitchell

When using the smalldatetime data type in a SQL database, how do I prevent
the field from storing the time? All I want in the field is the date, but is
keeps adding 12:00:00 AM at the end of the field.

Thanks!

13 Jan 2006 8:14 AM

Cor Ligthert [MVP]

Brian,

Simple you cannot DateTime adn SmallDateTime does as it says store the date
and time on the server.

However what is the problem as you can forever use the date part as

mydatetime.date

You don't win any bit by not storing the time.

I hope this helps,

Cor