-- Error: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

UPDATE table SET foo = CONVERT(DATETIME, '27.04.2007', 102) WHERE....