sql datetime

r.AddSampleDate >= cast( '2010-05-01 00:00:00.000' as datetime) AND r.AddSampleDate <= cast( '2010-05-31 23:59:59.999' as datetime)

 

上面这个语句不但查出了5月份的数据，而且还查出6月1日的数据。想半天没想明白。

 

后来改成 r.AddSampleDate >= cast( '2010-05-01 00:00:00.000' as datetime) AND r.AddSampleDate <= cast( '2010-05-31 23:59:59.998' as datetime) 这样就只查5月份的数据，难道发生进位了？记录下这个问题，sql版本：sql server 2005

 

 

顺便看到个smalldatetime，一并记录

--returns time as 12:35 SELECT CAST('2000-05-08 12:35:29.998' AS smalldatetime) GO --returns time as 12:36 SELECT CAST('2000-05-08 12:35:29.999' AS smalldatetime) GO

 

smalldatetime精确到分，而datetime精确到毫秒