select to_char(sysdate,'HH') from dual 可以取到hour,再用>'09'判断一下就好了
select to_char(sysdate,'hh:mm:ss') from dual
select to_char(sysdate,'hh:mm:ss') from dual
select * from attendace where to_char(leavetime,'HH24MISS')>'000000'; select * from attendace where trunc(leavetime ,'YYYY') BETWEEN TO_DATE('2000','YYYY') AND TO_DATE('2012','YYYY');
可以取到hour,再用>'09'判断一下就好了
select * from attendace where trunc(leavetime ,'YYYY')
BETWEEN TO_DATE('2000','YYYY') AND TO_DATE('2012','YYYY');