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;
Monday, October 26, 2020
Convert date to UTC TimeZone in Oracle
Subscribe to:
Post Comments (Atom)
Delete Row Button to all records of Interactive Report in Oracle Apex
1. add 'Delete' Del column to Report Query 2. Set the Following Properties for the DEL Column Type: Link Heading: Delete Targ...
-
[oracle@ODIGettingStarted ~]$ sqlplus sys as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 7 01:20:15 2019 Copyright (c) 1...
-
Oracle 11g: SQL> set serveroutput on; SQL> DECLARE 2 s varchar2(32767) := '{ "a": 1, "b": ["h...
-
CREATE TABLE STUDENT_FILES ( FILE_ID NUMBER, FILE_NAME VARCHAR2 (100), FILE_TYPE VARCHAR2 (500), FILE_CONTENT ...
No comments:
Post a Comment