oracle查詢emp前一個月入職的員工？
select ename,hiredate from emp where hiredate =to_date('1982/1/1','yyyy/mm/dd') 如果是要查詢1982-1-1后入職的應該是： select ename,hiredate from emp where hiredate >to_date('1982/1/1','yyyy/mm/dd')
網站導航
- zblogPHP模板zbpkf
- zblog免費模板zblogfree
- zblog模板學習zblogxuexi
- zblogPHP仿站zbpfang