C＃ 从ACCESS数据库中查询数据时如何把STRING转为DATETIME？

Question

comm = "select CARD_NUM,BUY_DATE,PRICE_CATEGORY,USER_NAME1 OPERATOR from E_COSTDETAIL where BUY_DATE BETWEEN #" + time1 + "# and #" + time2 + "# ";

数据库中的BUY_DATE是string格式存储的日期时间

Answer 1

comm = "select CARD_NUM,BUY_DATE,PRICE_CATEGORY,USER_NAME1 OPERATOR from E_COSTDETAIL where CAST (BUY_DATE AS datetime) BETWEEN #" + time1 + "# and #" + time2 + "# ";