select cast(cast(year(getdate()) as varchar(4))+'-'+cast(month(getdate()) as varchar(2)+'-'+cast(day(dateadd(day,-1,getdate())) as varchar(2) as datetime)
select cast(cast(year(getdate()) as varchar)+'-'+cast(month(getdate()) as varchar)+'-'+cast(day(dateadd(day,-1,getdate())) as varchar) as datetime)ORselect cast(convert(varchar(10),dateadd(day,-1,getdate()),120) as datetime)
select cast(cast(year(getdate()) as varchar)+'-'+cast(month(getdate()) as varchar)+'-'+cast(day(dateadd(day,-1,getdate())) as varchar) as datetime)
GOOD GOOD STUDY DAY DAY UP
select cast(cast(year(getdate()) as varchar(4))+'-'+cast(month(getdate()) as varchar(2))+'-'+cast(day(dateadd(day,-1,getdate())) as varchar(2)) as datetime)
MessageBox.Show(word + " " +code)
没想到运行是居然要把word转成double型
而不是想象的把code转成string型
DAY DAY UP