to_char(sysdate,'hhmiss') = '080000'to_char(sysdate,'hhmiss') between '075000' and '081000'
select decode(to_char(sysdate,'hh24:mi:ss'),'08:00:00',1,0) from dual 以上语句,如果是08:00:00 显示1,否显示0 select case sysdate when to_char(sysdate,'hh24:mi:ss')>='07:50:00' and to_char(sysdate,'hh24:mi:ss')<='08:10:00' then 1 else 0 end from dual以上判断是否在7:50到8:10之间,是输出1,否输出0
SELECT CASE WHEN TO_CHAR(SYSDATE,'HH24:MI:SS') = '08:00:00' THEN 1 WHEN TO_CHAR(SYSDATE,'HH24:MI:SS') BETWEEN '07:50:00' AND '08:00:00' THEN 2 ELSE 3 END FROM DUAL ; 看返回结果,返回1就是上午8点,返回2就是处于上午7:50与上午8点之间,否则返回3.
select decode(to_char(sysdate,'hh24:mi:ss'),'08:00:00',1,0) from dual SELECT CASE WHEN TO_CHAR(SYSDATE,'HH24:MI:SS') = '08:00:00' THEN 1 WHEN TO_CHAR(SYSDATE,'HH24:MI:SS') BETWEEN '07:50:00' AND '08:00:00' THEN 2 ELSE 3 END FROM DUAL
以上语句,如果是08:00:00 显示1,否显示0
select case sysdate
when to_char(sysdate,'hh24:mi:ss')>='07:50:00' and to_char(sysdate,'hh24:mi:ss')<='08:10:00'
then 1
else 0
end
from dual以上判断是否在7:50到8:10之间,是输出1,否输出0
WHEN TO_CHAR(SYSDATE,'HH24:MI:SS') BETWEEN '07:50:00' AND '08:00:00' THEN 2
ELSE 3 END FROM DUAL ;
看返回结果,返回1就是上午8点,返回2就是处于上午7:50与上午8点之间,否则返回3.
WHEN TO_CHAR(SYSDATE,'HH24:MI:SS') BETWEEN '07:50:00' AND '08:00:00' THEN 2
ELSE 3 END FROM DUAL