where 子句中的日期时间

2021-12-23 00:00:00 datetime sql filter sql-server-2005 sql-server

如何在sql的where子句中选择12/20/2008?

How can I select 12/20/2008 in where clause of sql?

服务器是SQL server 2005.

The server is SQL server 2005.

select * from tblErrorLog
where errorDate = '12/20/2008'

推荐答案

WHERE datetime_column >= '20081220 00:00:00.000'
  AND datetime_column < '20081221 00:00:00.000'

相关文章