我用此条查询语句查询 能查出2012-09-15 00:00:00 的数据 请大侠们指教
select * from RawAlterDetailInfo where RawAlterDetailInfo.EnterDate <= '2012-09-14 23:59:59'
select * from RawAlterDetailInfo where RawAlterDetailInfo.EnterDate <= '2012-09-14 23:59:59'
DECLARE @O SMALLDATETIME --这个地方如果是datetime类型,结果将会不同
DECLARE @i SMALLDATETIME --SET @o = '2012-09-15 00:00:00'
SET @i = '2012-09-14 23:59:59'SELECT CASE WHEN @o=@i THEN 'OK' ELSE 'Error' END
select * from RawAlterDetailInfo where
RawAlterDetailInfo.EnterDate <= '2012-09-15 00:00:000'--此处smalldatetime精度为分钟你可以改为select * from RawAlterDetailInfo where RawAlterDetailInfo.EnterDate <'2012-09-15'
@i DATETIME SET @o = '2012-09-15 00:00:00'
SET @i = '2012-09-14 23:59:59'SELECT CASE WHEN @o=@i THEN 'OK' ELSE 'Error' END所在用DATETIME类型就行了