时间函数用法

declare @tmSuffix datetimedeclare @curYear  varchar(2)declare @curMonth varchar(2)-- 当前数据库名declare @strCurDBName varchar(30)select @strCurDBName = name from master..sysDataBases where dbid = (select dbid from master..sysProcesses where spid = @@spid)-- 最近第一个月declare @strLastOne varchar(256)set @tmSuffix = getdate()set @curYear  = right(100 + DATEPART(year , @tmSuffix), 2)set @curMonth = right(100 + DATEPART(month, @tmSuffix), 2)-- 示例：当前数据库名DataBase,则历史数据库名格式为DataBase_1305,DataBase_1304set @strLastOne = @strCurDBName+ '_' + @curYear + @curMonth-- 最近第二个月declare @strLastTwo varchar(256)set @tmSuffix = dateadd(month, -1, @tmSuffix)set @curYear  = right(100 + DATEPART(year , @tmSuffix), 2)set @curMonth = right(100 + DATEPART(month, @tmSuffix), 2)set @strLastTwo = @strCurDBName + '_' + @curYear + @curMonth-- 最近第三个月declare @strLastThree varchar(256)set @tmSuffix = dateadd(month, -1, @tmSuffix)set @curYear  = right(100 + DATEPART(year , @tmSuffix), 2)set @curMonth = right(100 + DATEPART(month, @tmSuffix), 2)set @strLastThree = @strCurDBName + '_' + @curYear + @curMonth