摘要：
最近在把ASP代码翻译成aspx，总是碰到原sql错误。不熟悉oracle sql的我真是郁闷啊~~oracle中没有YEAR或者MONTH函数需要在SQL语句中实现截取date类型的，可使用extract函数原SQL：sqlMonthFound="SELECT DISTINCT out_date AS 日期, out_1 / 1.05 AS 销货收入, out_17 AS 来客数,(out_1 / out_17) / 1.05 AS 客单价 FROM account WHERE (store_id = '"&store_id&"' 阅读全文
