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...
-
CREATE TABLE PRODUCT (ID NUMBER, NAME VARCHAR2(100)); ALTER TABLE PRODUCT ADD CONSTRAINT PRODUCT_PK PRIMARY KEY(ID); INSERT INTO PRODUCT VAL...
-
CREATE OR REPLACE PROCEDURE send_mail ( p_msg_to IN VARCHAR2, p_msg_subject IN VARCHAR2, p_msg_text IN VARCHAR2, ...
-
add below script in js path: Interactive Grid (Region Type) --> Attributes --> JavaScript Initialization Code function(config) ...

No comments:
Post a Comment