当前月一号八点
select (case when DateName(hour,GETDATE()) < 8 and datepart(dd,GETDATE()) = 1
then CONVERT(varchar(7),dateadd(mm,-1,GETDATE()),120)
else CONVERT(varchar(7),GETDATE(),120)
end)+'-01 08:00:00'
下月一号八点
select (case when DateName(hour,GETDATE()) < 8 and datepart(dd,GETDATE()) = 1
then CONVERT(varchar(7),GETDATE(),120)
else CONVERT(varchar(7),dateadd(mm,1,GETDATE()),120)
end)+'-01 08:00:00'
年:select datepart(yy,getdate())
月:select datepart(mm,getdate())
日:select datepart(dd,getdate())