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大家帮忙看看,我试了好久,没整出来,只有请大家帮忙了!!!
解决方案 »
- redhat3位上可以安装64位的oracle11吗?
- 一个表上可以创建多个物化视图日志吗?
- 怎么根据主表来查询子表的数据?
- select to_number(2010-06-01) from dual
- 请一个oracle sql语句
- VC ADO oracle 操作后的结果如何写成excel
- OracleOraHome90TNSListener服务为什么老是启动失败?
- 关于锁表的问题
- 如何学好Oracle,成为一个合格的DBA,应该怎么做?请大家帮帮我
- 求帮忙! 怎么把cgjg 查出来的 小于0的数据改为 0,其他的不变。 case when 或者 decode.
- 有谁知道forall和merge的不同之处吗?
- Oracle report - formate is TRF,请教
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')) 多了个括号