oracle中sql把数字转文字,Oracle SQL字符串到数字转换

我有一个表格，其中的列类型是varchar2，并保存诸如'22：00'或“13:30”之类的数据。 我试图将该数字与当前时间进行比较，如果当前时间在该时间之前，请选择数据。Oracle SQL字符串到数字转换

这里是我当前的代码：

select DISTINCT BBT_JOURNEYSTOPS.SERVICE "Service", BBT_JOURNEYSTOPS.STOP_REFERENCE "StopNo",

STOP_NAME "Near", BBT_STOPS.ROAD_NAME "On", BBT_JOURNEYSTOPS.JOURNEYTIME "Duration"

from BBT_JOURNEYSTOPS

inner join BBT_WEEKLYSCHEDULE

on BBT_WEEKLYSCHEDULE.SERVICE = BBT_JOURNEYSTOPS.SERVICE

inner join BBT_STOPS

on BBT_JOURNEYSTOPS.STOP_REFERENCE = BBT_STOPS.STOPREF

where (UPPER(BBT_JOURNEYSTOPS.SERVICE) LIKE UPPER('%'|| :route || '%')) AND

(TO_NUMBER(SUBSTR(BBT_WEEKLYSCHEDULE.TIMEUNTIL, 1, 2)) > (SELECT TO_NUMBER(SYSDATE, 'HH24') "NOW" FROM DUAL));

这是有问题的WHERE语句。我得到的错误代码是

ORA-01481: invalid number format model

01481. 00000 - "invalid number format model"

*Cause: The user is attempting to either convert a number to a string

via TO_CHAR or a string to a number via TO_NUMBER and has

supplied an invalid number format model parameter.

*Action: Consult your manual.

2015-04-21

Craig