using smalldatetime to ONLY store date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian Mitchell - 13 Jan 2006 00:50 GMT

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!

Reply to this Message

Cor Ligthert [MVP] - 13 Jan 2006 08:14 GMT

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

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...