-
注册真麻烦 初学数据Lv2
发表于2021-3-6 17:40
悬赏10
已解决
楼主
SELECT * FROM GENSTAGING WHERE PROCESS_END_TIME BETWEEN TO_DATE('20210301 08:00:00','yyyymmdd HH24:MI:SS') AND TO_DATE('20210303 20:00:00','yyyymmdd HH24:MI:SS')
大哥啊,我想每次动态运行都能查询近28天的数据,如何实现呢?
大哥啊,我想每次动态运行都能查询近28天的数据,如何实现呢?
最佳答案
注册真麻烦 发表于 2021-3-6 18:55
BETWEEN TO_DATE(' 20:00:00','yyyymmdd HH24:MI:SS')
AND TO_DATE(' 20:00:00','yyyymmdd HH24:MI: ...
关贴总结
BETWEEN TO_DATE('<#=offsetdate(today(),0,0,-7)#> 20:00:00','yyyymmdd HH24:MI:SS')
AND TO_DATE('<#=offsetdate(today(),0,0,0)#> 20:00:00','yyyymmdd HH24:MI:SS')
感谢楼主分享!
3个回答
BETWEEN TO_DATE('<#=offsetdate(today(),0,0,-7)#> 20:00:00','yyyymmdd HH24:MI:SS')
AND TO_DATE('<#=offsetdate(today(),0,0,0)#> 20:00:00','yyyymmdd HH24:MI:SS')
-
ESENSOFT官方技术支持 管理员
地板
注册真麻烦 发表于 2021-3-6 18:55
BETWEEN TO_DATE(' 20:00:00','yyyymmdd HH24:MI:SS')
AND TO_DATE(' 20:00:00','yyyymmdd HH24:MI: ...
关贴总结
BETWEEN TO_DATE('<#=offsetdate(today(),0,0,-7)#> 20:00:00','yyyymmdd HH24:MI:SS')
AND TO_DATE('<#=offsetdate(today(),0,0,0)#> 20:00:00','yyyymmdd HH24:MI:SS')
感谢楼主分享!