oracle只取数字,oracle – 获取错误 – ORA-01858：找到了一个非数字字符,其中包含数字...

我在下面的sql中收到错误：

ORA-01858: a non-numeric character was found where a numeric was expected

SELECT c.contract_num,CASE

WHEN ( MAX (TO_CHAR (TO_DATE (c.event_dt,'YYYY-MM-DD'),'MMDD'))

- MIN (TO_CHAR (TO_DATE (c.event_dt,'MMDD')))

/ COUNT (c.event_occurrence) < 32

THEN

'Monthly'

WHEN ( MAX (

TO_CHAR (TO_DATE (c.event_dt,'MMDD'))

- MIN (

TO_CHAR (TO_DATE (c.event_dt,'MMDD')))

/ COUNT (c.event_occurrence) >= 32

AND ( MAX (

TO_CHAR (TO_DATE (c.event_dt,'MMDD')))

/ COUNT (c.event_occurrence) < 91

THEN

'Quarterley'

ELSE

'Yearly'

END

FROM ps_ca_bp_events c

GROUP BY c.contract_num;