>Hey George
>
>I wish I had known that when I was designing my stuff, I have several (12) datetime fields in one table, do you know if I change them to a smalldatetime if it will hold the basic data (Month,Date,Year,Hours,Minutes)? Or will it it blank them out?
>
Kirk,
My experience is that it won't blank them out. However, some resolution (accuracy) will be lost. From SQL Server Books on-line:
datetime and smalldatetime
datetime
Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds.
smalldatetime
Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute.You can expect rounding to occur if you convert.
George
Ubi caritas et amor, deus ibi est