SELECT SYSDATE,
SYSTIMESTAMP,
CURRENT_DATE,
CURRENT_TIMESTAMP,
TO_CHAR (SYSTIMESTAMP AT TIME ZONE 'UTC', 'YYYY/MM/DD HH24:MI:SS TZD')
DT_AS_UTC,
TO_CHAR (SYSTIMESTAMP AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS')
DT_AS_UTC,
TO_CHAR (SYS_EXTRACT_UTC (SYSTIMESTAMP), 'yyyy-mm-dd"T"hh24:mi:ss"Z"')
DT_AS_UTC
FROM DUAL;
No comments:
Post a Comment