sql = "select userorder,useraccount,to_char(insertdate,'yyyy/mm/dd') insertdate from insert_tab where insertdate between fromdate and todate";
这个sql语句是错误的,where insertdate between fromdate and todate处有错误。报错说有无效列名。我不知道怎么修改了。谁告诉我
...全文
11413打赏收藏
select语句的问题
sql = "select userorder,useraccount,to_char(insertdate,'yyyy/mm/dd') insertdate from insert_tab where insertdate between fromdate and todate"; 这个sql语句是错误的,where insertdate between fromdate and todate处有错误。报错说有无效列名。我不知道怎么修改了。谁告诉我
sql = "select userorder,useraccount,to_char(insertdate,'yyyy/mm/dd') insertdate from insert_tab where insertdate between to_data('"+fromdate+"','yyyy-mm-dd') and to_date('"+todate+"','yyyy-mm-dd')";