oracle 判断条件不在某一时间范围内(not between)
判断条件在某一段时间范围内用 BETWEEN
SELECT *
FROM P_VOTE t
WHERE to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') BETWEEN to_char(t.BEGIN_TIME, 'yyyy-mm-dd hh24:mi:ss') AND to_char(t.END_TIME, 'yyyy-mm-dd hh24:mi:ss')
...
原创
2018-07-20 10:23:16 ·
12550 阅读 ·
0 评论