Sql Server Datetime Data Type. When we do that, sql server performs an implicit conversion in order for the data to “fit” the new data type. However, the datetime value continues to be rounded up.
When the conversion is from date, the year, month, and day are copied. Introduction to datetimeoffset data type. This is very much needed when we require to set a variable in ssis from a result set returned from execute sql task or when we need to pass parameters to sql query.
