将时间转换成数字,把数字转换成时间,均匀取一定时间间隔(比如每91秒取一条记录)内的符合条件的记录
/****** Script for SelectTopNRows command from SSMS ******/SELECT [id] ,[tagDate],CAST(tagdate as float)*10000000000 as numdate ,[HZ105_315HH] ,[HZ105_DO315AI] ,[HZ105_FI315AI] ,[HZ105_PH315AI] ,[HZ105_PI315AI] ,[HZ105_TI315AI] ,[HZ105_WI315AI] ,[HZ105_ZS315AI] FROM [IhHisdata].[dbo].[dat_hisdata] where CAST( CAST(tagdate as float)*10000000000 as decimal)