sql - 如何选择早于特定日期的行？

Question

我尝试过使用:

SELECT * FROM dbo.admin_IVM_ITEMMAST WHERE LSTSAL_DATE <= '2016-09-31 00:00:00.000'

但是当我执行查询时，我得到了这个错误。

错误:

Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

列名是:LSTSAL_DATE，列内的典型字符串是:2013-05-02 00:00:00.000

Answer 1

九月只有30天!

SELECT * FROM dbo.admin_IVM_ITEMMAST WHERE LSTSAL_DATE <= '2016-09-30 00:00:00.000'