怎么不行啊我把我的sql贴出来,大家看看 select bc_bh,yy_bh,fc_rq,nvl(jg,0)+nvl(zjje,0),ckzd ,qcsj from d_yybczd where (tkzd_bh = '2330') and fc_rq >= to_date('2004-09-09 09:00:00','yyyy-mm-dd hi24:mi:ss') and fc_rq <= to_date('2004-09-09 23:00:00','yyyy-mm-dd hi24:mi:ss') order by fc_rq 系统提示:日期格式无法识别
select bc_bh,yy_bh,fc_rq,nvl(jg,0)+nvl(zjje,0),ckzd ,qcsj
from d_yybczd
where (tkzd_bh = '2330')
and fc_rq >= to_date('2004-09-09 09:00:00','yyyy-mm-dd hi24:mi:ss')
and fc_rq <= to_date('2004-09-09 23:00:00','yyyy-mm-dd hi24:mi:ss')
order by fc_rq
系统提示:日期格式无法识别
应该是hh24 不是hi24 !!!