50分求一查询语句

Question

SELECT substr(to_char(now_time,'yyyymmdd'),1,8),
SUM(nowbuywater_measure) AS total_buymeasure, 
SUM(nowwritecard_measure) AS total_writemeasure,
SUM(BUYWATER_MONEY)+SUM(MONEY_SZYF)+SUM(MONEY_WU) AS total_buyprice 
FROM ICEXCHANGE_INFO  where operator_id= '100001'
group by substr(to_char(now_time,'yyyymmdd'),1,8)
now_time:date,其余是数字型,
这条语句问题在哪呢? 报的错是 无效数字

Answer 1

SELECT to_char(now_time, 'yyyymmdd'),
       SUM(nowbuywater_measure) AS total_buymeasure,
       SUM(nowwritecard_measure) AS total_writemeasure,
       SUM(BUYWATER_MONEY) + SUM(MONEY_SZYF) + SUM(MONEY_WU) AS total_buyprice
  FROM ICEXCHANGE_INFO
 where operator_id = 100001
 group by to_char(now_time, 'yyyymmdd')

Answer 2

operator_id  是 vachar2 的,忘了说了

Answer 3

substr可以去掉。
但不影响啊
你再确定下是不是有的字段非数值型的

Answer 4

结帖,明白了,谁动了我的数据库,把now_time改成varchar2类型了,晕,才告诉我.谢谢大家的回复