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(" & DateAdd("n", -330, Now) & ",'yyyy-mm-dd hh24:mi:ss') and to_date( " & Now & ",'yyyy-mm-dd hh24:mi:ss')
order by time_point大家帮忙看看,我试了好久,没整出来,只有请大家帮忙了!!!
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(" & DateAdd("n", -330, Now) & ",'yyyy-mm-dd hh24:mi:ss') and to_date( " & Now & ",'yyyy-mm-dd hh24:mi:ss')
order by time_point大家帮忙看看,我试了好久,没整出来,只有请大家帮忙了!!!
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(" & DateAdd("n", -330, Now) & ",'yyyy-mm-dd hh24:mi:ss') and to_date( " & Now & ",'yyyy-mm-dd hh24:mi:ss')
order by time_point
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(" & DateAdd("n", -330, Now) & ", 'yyyy-mm-dd hh24:mi:ss') and to_date(" & Now & ", 'yyyy-mm-dd hh24:mi:ss')
order by time_pointlike '%:30:00')) and time_point 中间多了一个括号!
--try it
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(" & DateAdd("n", -330, Now) & ", 'yyyy-mm-dd hh24:mi:ss') and
to_date(" & Now & ", 'yyyy-mm-dd hh24:mi:ss')
order by time_point
to_char(time_point, 'yyyy-mm-dd hh24:mi:ss') like '%:30:00'))这段代码请改成:
to_char(time_point, 'mi:ss') in ('00:00', '30:00')之后的语句就有点怪异了
改为:
to_date('" & DateAdd …单引号
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')) 多了个括号