아래는 오라클에서의 결과입니다.
SCOTT@ORA11GR2>SELECT USER, CURRENT_DATE, CURRENT_TIMESTAMP FROM DUAL;
USER CURRENT_DATE CURRENT_TIMESTAMP
------------------------------ ------------ ---------------------------------------
SCOTT 15-DEC-12 15-DEC-12 03.14.24.290000 PM +09:00
SCOTT@ORA11GR2>SELECT USER, SYSDATE, SYSTIMESTAMP FROM DUAL;
USER SYSDATE SYSTIMESTAMP
------------------------------ ------------ ---------------------------------------
SCOTT 15-DEC-12 15-DEC-12 03.14.35.495000 PM +09:00
SCOTT@ORA11GR2>
PostgreSQL 에서 위에 대응되는 SQL 을 수행해보겠습니다.
scott@[local]:5432 scottdb#SQL>
SELECT CURRENT_USER, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP;
current_user | date | timetz | now
--------------+------------+--------------------+-------------------------------
scott | 2012-12-15 | 15:17:08.445125+09 | 2012-12-15 15:17:08.445125+09
scott@[local]:5432 scottdb#SQL>
