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

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

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

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

Convert.ToDateTime(BUY_DATE)
直接转换就行了 ，保证你的字符串格式符合日期格式