SQL语句中如何将字符串转化为日期类型?

比如,利用SQL语句如何将'2006-07-01'的字符串转化为日期型数据?谢谢!
[51 byte] By [chequan-chequan] at [2008-1-6]
# 1
select cast('2006-07-01' as datetime)
hellowork-一两清风 at 2007-10-25 > top of Msdn China Tech,MS-SQL Server,疑难问题...
# 2
select cast('2006-07-01' as datetime)
# 3
谢谢!试试去!
chequan-chequan at 2007-10-25 > top of Msdn China Tech,MS-SQL Server,疑难问题...
# 4
select convert(datetime,'2006-07-01')