SELECT *
FROM Out_Balance
WHERE (Balance_Date BETWEEN CAST('"&Request.Form("Date_B")&"' AS datetime) AND
CAST('"&Request.Form("Date_E")&"' AS datetime))
ORDER BY Balance_Date DESC
出错提示从字符串行到datetime型出现语法错误!!
...全文
4715打赏收藏
这样为什么不行?其中Balance_Date的类型是datetime
SELECT * FROM Out_Balance WHERE (Balance_Date BETWEEN CAST('"&Request.Form("Date_B")&"' AS datetime) AND CAST('"&Request.Form("Date_E")&"' AS datetime)) ORDER BY Balance_Date DESC 出错提示从字符串行到datetime型出现语法错误!!
SELECT *
FROM Out_Balance
WHERE (Balance_Date BETWEEN CAST('"&Request.Form("Date_B")&"' AS datetime) AND
CAST('"&Request.Form("Date_E")&"' AS datetime))
ORDER BY Balance_Date DESC