求教“将字符形变量转化成日期形变量”的sql语句？

[zhxf]

求教“将字符形变量转化成日期形变量”的sql语句？

[weixiao51]

convert (datetime, 变量, 102)

[welyngj]

declare @t varchar(20)
set @t='2002-9-20'
select cast(@t as datetime)

[mjhnet]

select convert(datetime,'2003-01-01')

[愉快的登山者]

select cast('20030101' as datetime)

[sdhdy]

select cast('2003-01-01' as datetime)

[aierong]

--yyyy-mm-dd
declare @a varchar(100)
select @a=convert(varchar(10),getdate(),120)
select @a

--yyyymmdd
declare @a varchar(100)
select @a=convert(varchar(10),getdate(),112)
select @a

--yyyy/mm/dd
declare @a varchar(100)
select @a=convert(varchar(10),getdate(),111)
select @a