请问在查询(SELECT * FROM t_hr_leavedetail where fstartdatereal>TO_CH)时提示这样的错误,该如何处理?
complete! use time:110 end time Thu Nov 11 11:48:57 CST 2010null
Caused exception message is: translate sql exception, message is
parse error. detail message is :
Error: expect token <Punctuation,)>, but current token is <Punctuation,:>, at line 1, column 74)
source sql is :
SELECT * FROM t_hr_leavedetail where fstartdatereal>TO_CHAR(2010-10-2600:00:00, 'YYYY-MM-DD HH24:MI:SS AM DY')
complete! use time:75 end time Thu Nov 11 11:48:42 CST 2010null
Caused exception message is: translate sql exception, message is
format sql error. target database is 'Oracle9' detail message is :
unexpect expression: 'TO_CHAR('2010-10-2600:00:00', 'YYYY-MM-DD HH24:MI:SS AM DY')'
source sql is :
SELECT * FROM t_hr_leavedetail where fstartdatereal>TO_CHAR('2010-10-2600:00:00', 'YYYY-MM-DD HH24:MI:SS AM DY')
complete! use time:90 end time Thu Nov 11 11:47:44 CST 2010null
Caused exception message is: ORA-01843: 无效的月份
complete! use time:50 end time Thu Nov 11 11:46:21 CST 2010
complete! use time:140 end time Thu Nov 11 11:46:02 CST 2010null
Caused exception message is: translate sql exception, message is
format sql error. target database is 'Oracle9' detail message is :
unexpect expression: 'TO_CHAR(wherefstratdatereal, 'YYYY-MM-DD HH24:MI:SS AM DY')'
source sql is :
SELECT TO_CHAR(wherefstratdatereal, 'YYYY-MM-DD HH24:MI:SS AM DY') FROM t_hr_leavedetail