sql server 2005用between子句选择日期 [英] sql server 2005 select date with between clause

问题描述

SELECT    *  FROM         D_BILL
WHERE     (BILL_DAT BETWEEN 24 - 09 - 2013 19 : 19 : 13 AND 24 - 09 - 2013 19 : 19 : 13)

19附近的错误请理清错误

Error near 19 please sort out the error

SELECT    *  FROM         D_BILL
WHERE     (BILL_DAT BETWEEN '24 - 09 - 2013 19 : 19 : 13' AND '24 - 09 - 2013 19 : 19 : 13')

错误无法将varchar转换为日期时间





sql server 2005

Error cannot convert varchar to datetime


sql server 2005

推荐答案

尝试：

Try:

SELECT * FROM D_BILL WHERE BILL_DAT BETWEEN '2013-09-24 19:19:13' AND '2013-09-24 19:19:14'

引号和间距很重要。

The quotes and spacing are important.

这篇关于sql server 2005用between子句选择日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！