日期:2014-05-18 浏览次数:20596 次
select convert(datetime,convert(varchar(11),getdate(),120)) date, dateadd(mi,-5,convert(datetime,convert(varchar(11),getdate(),120) +right(100+number/2,2)+':'+right(100+number%2*30,2))) as st, dateadd(mi,5,convert(datetime,convert(varchar(11),getdate(),120) +right(100+number/2,2)+':'+right(100+number%2*30,2))) as et from master..spt_values where [type] = 'p' and number between 0 and 47 /****************** date st et ----------------------- ----------------------- ----------------------- 2011-09-01 00:00:00.000 2011-08-31 23:55:00.000 2011-09-01 00:05:00.000 2011-09-01 00:00:00.000 2011-09-01 00:25:00.000 2011-09-01 00:35:00.000 2011-09-01 00:00:00.000 2011-09-01 00:55:00.000 2011-09-01 01:05:00.000 2011-09-01 00:00:00.000 2011-09-01 01:25:00.000 2011-09-01 01:35:00.000 2011-09-01 00:00:00.000 2011-09-01 01:55:00.000 2011-09-01 02:05:00.000 2011-09-01 00:00:00.000 2011-09-01 02:25:00.000 2011-09-01 02:35:00.000 2011-09-01 00:00:00.000 2011-09-01 02:55:00.000 2011-09-01 03:05:00.000 2011-09-01 00:00:00.000 2011-09-01 03:25:00.000 2011-09-01 03:35:00.000 2011-09-01 00:00:00.000 2011-09-01 03:55:00.000 2011-09-01 04:05:00.000 2011-09-01 00:00:00.000 2011-09-01 04:25:00.000 2011-09-01 04:35:00.000 2011-09-01 00:00:00.000 2011-09-01 04:55:00.000 2011-09-01 05:05:00.000 2011-09-01 00:00:00.000 2011-09-01 05:25:00.000 2011-09-01 05:35:00.000 2011-09-01 00:00:00.000 2011-09-01 05:55:00.000 2011-09-01 06:05:00.000 2011-09-01 00:00:00.000 2011-09-01 06:25:00.000 2011-09-01 06:35:00.000 2011-09-01 00:00:00.000 2011-09-01 06:55:00.000 2011-09-01 07:05:00.000 2011-09-01 00:00:00.000 2011-09-01 07:25:00.000 2011-09-01 07:35:00.000 2011-09-01 00:00:00.000 2011-09-01 07:55:00.000 2011-09-01 08:05:00.000 2011-09-01 00:00:00.000 2011-09-01 08:25:00.000 2011-09-01 08:35:00.000 2011-09-01 00:00:00.000 2011-09-01 08:55:00.000 2011-09-01 09:05:00.000 2011-09-01 00:00:00.000 2011-09-01 09:25:00.000 2011-09-01 09:35:00.000 2011-09-01 00:00:00.000 2011-09-01 09:55:00.000 2011-09-01 10:05:00.000 2011-09-01 00:00:00.000 2011-09-01 10:25:00.000 2011-09-01 10:35:00.000 2011-09-01 00:00:00.000 2011-09-01 10:55:00.000 2011-09-01 11:05:00.000 2011-09-01 00:00:00.000 2011-09-01 11:25:00.000 2011-09-01 11:35:00.000 2011-09-01 00:00:00.000 2011-09-01 11:55:00.000 2011-09-01 12:05:00.000 2011-09-01 00:00:00.000 2011-09-01 12:25:00.000 2011-09-01 12:35:00.000 2011-09-01 00:00:00.000 2011-09-01 12:55:00.000 2011-09-01 13:05:00.000 2011-09-01 00:00:00.000 2011-09-01 13:25:00.000 2011-09-01 13:35:00.000 2011-09-01 00:00:00.000 2011-09-01 13:55:00.000 2011-09-01 14:05:00.000 2011-09-01 00:00:00.000 2011-09-01 14:25:00.000 2011-09-01 14:35:00.000 2011-09-01 00:00:00.000 2011-09-01 14:55:00.000 2011-09-01 15:05:00.000 2011-09-01 00:00:00.000 2011-09-01 15:25:00.000 2011-09-01 15:35:00.000 2011-09-01 00:00:00.000 2011-09-01 15:55:00.000 2011-09-01 16:05:00.000 2011-09-01 00:00:00.000 2011-09-01 16:25:00.000 2011-09-01 16:35:00.000 2011-09-01 00:00:00.000 2011-09-01 16:55:00.000 2011-09-01 17:05:00.000 2011-09-01 00:00:00.000 2011-09-01 17:25:00.000 2011-09-01 17:35:00.000 2011-09-01 00:00:00.000 2011-09-01 17:55:00.000 2011-09-01 18:05:00.000 2011-09-01 00:00:00.000 2011-09-01 18:25:00.000 2011-09-01 18:35:00.000 2011-09-01