다음 오라클 쿼리를 PostgreSQL 에서는 어떻게 바꿀수 있을까요?
SELECT
ENAME,
LENGTH(ENAME),
HIREDATE,
SUBSTR(TO_CHAR(HIREDATE,'YYYY-MM-DD'),1,4),
TO_CHAR(HIREDATE,'YYYY')
FROM EMP;
정답은 "수정없이 그대로 사용하면 된다" 입니다.
scott@[local]:5432 scottdb#SQL> SELECT
SUBSTR(TO_CHAR(HIREDATE,'YYYY-MM-DD'),1,4),
ename | length | hiredate | substr | to_char
--------+--------+------------+--------+---------
SMITH | 5 | 1980-12-17 | 1980 | 1980
ALLEN | 5 | 1981-02-20 | 1981 | 1981
WARD | 4 | 1981-02-22 | 1981 | 1981
JONES | 5 | 1981-04-02 | 1981 | 1981
MARTIN | 6 | 1981-09-28 | 1981 | 1981
BLAKE | 5 | 1981-05-01 | 1981 | 1981
CLARK | 5 | 1981-06-09 | 1981 | 1981
SCOTT | 5 | 1982-12-09 | 1982 | 1982
KING | 4 | 1981-11-17 | 1981 | 1981
TURNER | 6 | 1981-09-08 | 1981 | 1981
ADAMS | 5 | 1983-01-12 | 1983 | 1983
JAMES | 5 | 1981-12-03 | 1981 | 1981
FORD | 4 | 1981-12-03 | 1981 | 1981
MILLER | 6 | 1982-01-23 | 1982 | 1982
scott@[local]:5432 scottdb#SQL>