今天,由于需求要求,需要拿一段时间段内,精确到秒的时间列表,于是乎查阅资料,有了以下结果:
select convert(varchar(19),DATEADD(SS,number,DATEADD(MINUTE,-10,GETDATE())),121) as MonitorTime
from master..spt_values twhere type = 'P'and number between 0 and DATEDIFF(SS,DATEADD(MINUTE,-10,GETDATE()),GETDATE())