declare @SD datetime,@ED datetime
set @SD = cast( (cast(@Month as varchar) + '-1-' + cast(@year as varchar)) as datetime)
set @ED = dateadd(mm,1,@SD)
这语句实现了什么?
...全文
131115打赏收藏
存储过程中cast是什么意思?
declare @SD datetime,@ED datetime set @SD = cast( (cast(@Month as varchar) + '-1-' + cast(@year as varchar)) as datetime) set @ED = dateadd(mm,1,@SD) 这语句实现了什么?
cast(@Month as varchar) 将@month转换为字符串类型,cast(@year as varchar)一样
cast( (cast(@Month as varchar) + '-1-' + cast(@year as varchar)) as datetime)将(cast(@Month as varchar) + '-1-' + cast(@year as varchar))所得到的字符串类型转化为时间类型