Sqlserver中将字符串类型转换为datetime类型

DECLARE @str varchar(20);

DECLARE @dt datetime;

set @str='2012'+'-10'+'-10';

set @dt=CAST(@str AS datetime);

select @dt