title: Convert datetime to smalldatetime in SQL stored procedure that preserves the time?
body: <p>I have a stored procedure that gets data from a database that utilizes a column with type datetime (there is a valid time value in it) and it updates a table in another database that happens to use the smalldatetime type.  When trying to convert from the datetime type to the smalldatetime type, I'm losing the time portion of the date.  For some strange reason the date is being rounded up by a day on me.  Is there some sort of special convert statement from datetime to smalldatetime that preserves the time portion of that date value?</p>