本汪在项目里碰到了精确到秒的时间段截取,
就随便记录下
下面这条语句可以在PLSQL里试运行,
select t.*, t.rowid
from user t where
to_char(t.update_time,'yyyymmddhh24miss')
> (to_char(sysdate,'yyyyMMdd')||'080000')
and
to_char(t.update_time,'yyyymmddhh24miss')
< = (to_char(sysdate+1,'yyyyMMdd')||'075959')
转换后的格式,为纯数字的字符串(不会出现多位少位的情况,比如:“2020-01-02 01:00:00”会变为“20200102010000”,而不是“102001021”这种)
select to_char(t.update_time,'yyyymmddhh24miss')
time from WECHAT_USER t
order by t.update_time desc
可以直接复制使用的oracle代码如下:
<script>
select t.*, t.rowid
from user t where
to_char(t.update_time,'yyyymmddhh24miss')
> (to_char(sysdate,'yyyyMMdd')||'000000')
and
to_char(t.update_time,'yyyymmddhh24miss')
< (to_char(sysdate+1,'yyyyMMdd')||'075959')
</script>