Data that is recognizable as a date can be converted to datetime, smalldatetime, date or time. Incorrect month names lead to syntax errors. Dates that fall outside the acceptable range for the datatype lead to arithmetic overflow errors.
When datetime values are converted to smalldatetime, they are rounded up to the nearest minute.
