using smalldatetime to ONLY store date

  • Thread starter Thread starter Brian Mitchell
  • Start date Start date
B

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!
 
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
 
Back
Top