我用语句select ename,to_char(hiredate,'yyyymmdd') as c from emp ;查询结果为:
ENAME C
SMITH 19801217
ALLEN 19810220
WARD 19810222
JONES 19810402
MARTIN 19810928
BLAKE 19810501
CLARK 19810609
SCOTT 19870419
KING 19811117
TURNER 19810908
ADAMS 19870523
JAMES 19811203
FORD 19811203
MILLER 19820123
已选择14行。
现在我想查询所有1981年的,该怎么写语句?
除了select ename,to_char(hiredate,'yyyymmdd') as c from emp where hiredate between to_date('19810101','yyyymmdd') and to_date('19811231','yyyymmdd');
还有什么办法呢?