In SQL Server, between has an error of 30 seconds when querying the date.

In the SQL Server 2005 SP3 environment, we found the following strange phenomenon when we accidentally used between to query date data: paymentdate is smalldatetime

23:59:59 is still outside 0:00:00?

Continue to try and find that the time is reduced31Seconds to achieve the desired effect, as shown below:

Summary:When between is used to limit the time range, the boundary value of the range should be reduced inward.31Seconds to reach the time range that truly meets your needs.

I wonder if this is an "negligible error "?

Supplement:

Later view msdn knowledge :( http://msdn.microsoft.com/zh-cn/library/ms182418.aspx)

The time error of smalldatetime is 1 minute. Values smaller than or equal to 29.998 seconds are rounded down to the nearest minute. values greater than or equal to 29.999 seconds are rounded up to the nearest minute.