var date = parseInt(reverseString(hexPayload.substring(0,8)),16).toString(10);result.Volume1 = volume(reverseString(hexPayload.substring(18,26))) + 'meterCube' + date.getHours
我使用以下查询,该查询有时工作良好,但有时会导致将varchar转换为numeric.Where时出错,是不是出错了??select * where (convert(decimal(10,6),substring(data,2,10)) between 25 and 635 )
AND(convert(decimal(10,6),substring(data,CHARINDEX(',',data)+1,10)) between -99 and -9 ) ;