SELECT START_WORK_TIME FROM TY_EMBASIC WHERE FLAG = 0 -- 参加工作时间
select to_char(sysdate,'mm') as nowMonth from dual; --获取时间的月
select to_char(sysdate,'dd') as nowDay from dual; --获取时间的日
-- 查找出参加工作时间的日期是今天的人
SELECT EMPID,NAME,START_WORK_TIME,to_char(START_WORK_TIME,'mm') ||'-'|| to_char(START_WORK_TIME,'dd') AS DAYS
FROM TY_EMBASIC WHERE FLAG = 0
AND to_char(START_WORK_TIME,'mm') = to_char(sysdate,'mm') AND to_char(START_WORK_TIME,'dd') = to_char(sysdate,'dd')