操作系统:Win7,WinServer2008R2
数据库:MSSqlServer2008
语言:SQL
功能:字符串转时间查询
select COUNT(*) from [TempSensorData].[dbo].[TemperatureHumidityMessage] where
[MessageTime]>CAST('2013-4-2 17:00:00:000' as datetime) and
[MessageTime]<CAST('2013-4-3 9:00:00:000' as datetime)