select to_char(recording_date,'yyyy-mm-dd hh24:mi:ss'),to_char(time_point,'yyyy-mm-dd hh24:mi:ss'),tw_value from pati_tw_rec where (to_char(time_point,'yyyy-mm-dd hh24:mi:ss') like '%:00:00' or to_char(time_point,'yyyy-mm-dd hh24:mi:ss') like '%:30:00')) and time_point between to_date('2008-12-11 10:44:32','yyyy-mm-dd hh24:mi:ss') and to_date( '2008-12-11 16:14:32','yyyy-mm-dd hh24:mi:ss') order by time_point为什么说sql没有结束啊??出现00933
select to_char(recording_date,'yyyy-mm-dd hh24:mi:ss'),to_char(time_point,'yyyy-mm-dd hh24:mi:ss'),tw_value from pati_tw_rec where (to_char(time_point,'yyyy-mm-dd hh24:mi:ss') like '%:00:00' or to_char(time_point,'yyyy-mm-dd hh24:mi:ss') like '%:30:00')) and time_point between to_date('2008-12-11 10:44:32','yyyy-mm-dd hh24:mi:ss') and to_date( '2008-12-11 16:14:32','yyyy-mm-dd hh24:mi:ss') order by time_point为什么说sql没有结束啊??出现00933
to_char(time_point,'yyyy-mm-dd hh24:mi:ss'),
tw_value
from pati_tw_rec
where (to_char(time_point,'yyyy-mm-dd hh24:mi:ss') like '%:00:00' or
to_char(time_point,'yyyy-mm-dd hh24:mi:ss') like '%:30:00'))这里多了 and time_point between to_date('2008-12-11 10:44:32','yyyy-mm-dd hh24:mi:ss') and to_date( '2008-12-11 16:14:32','yyyy-mm-dd hh24:mi:ss') order by time_poin
from pati_tw_rec
where (to_char(time_point,'yyyy-mm-dd hh24:mi:ss') like '%:00:00' or to_char(time_point,'yyyy-mm-dd hh24:mi:ss') like '%:30:00'))
and time_point between to_date('2008-12-11 10:44:32','yyyy-mm-dd hh24:mi:ss') and to_date( '2008-12-11 16:14:32','yyyy-mm-dd hh24:mi:ss')
order by time_point要养成写标准sql语句的习惯
select to_char(recording_date,'yyyy-mm-dd hh24:mi:ss') aa,to_char(time_point,'yyyy-mm-dd hh24:mi:ss') bb,tw_value
from pati_tw_rec
where (to_char(time_point,'yyyy-mm-dd hh24:mi:ss') like '%:00:00' or to_char(time_point,'yyyy-mm-dd hh24:mi:ss') like '%:30:00'))
and time_point between to_date('2008-12-11 10:44:32','yyyy-mm-dd hh24:mi:ss') and to_date( '2008-12-11 16:14:32','yyyy-mm-dd hh24:mi:ss')
order by time_point ;
to_char(time_point, 'yyyy-mm-dd hh24:mi:ss'),
tw_value
from pati_tw_rec
where to_char(time_point, 'mi:ss') in ('30:00', '00:00')
and time_point between
to_date('2008-12-11 10:44:32', 'yyyy-mm-dd hh24:mi:ss') and
to_date('2008-12-11 16:14:32', 'yyyy-mm-dd hh24:mi:ss')
order by time_point
这样的错误自己解决的多了,慢慢就会很快定位出错误在哪
要保持sql语句的规范