Hello Team,
kindly advise how to insert data with timestamp and timestamp with local timezone datatypes?
CREATE TABLE "OFSTRIM"."TIMETEST"
( "ID" NUMBER,
"NAME" VARCHAR2(100 BYTE),
"DATE_DATE" DATE,
"DATE_TIMESTAMP" TIMESTAMP (6),
"DATE_TIMESTAMP_TZ" TIMESTAMP (6) WITH TIME ZONE,
"DATE_TIMESTAMP_LOCAL_TZ" TIMESTAMP (6) WITH LOCAL TIME ZONE,
CONSTRAINT "TIMETEST_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
//insert statement
INSERT INTO OFSTRIM.TIMETEST (ID, NAME, DATE_DATE, DATE_TIMESTAMP, DATE_TIMESTAMP_TZ, DATE_TIMESTAMP_LOCAL_TZ)
VALUES (12, 'c', TO_DATE('2022-07-07 09:01:30', 'YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2022-07-07 09:01:32', 'YYYY-MM-DD HH24:MI:SS'),
SYSDATE,SYSDATE);
Kindly help me with the insert statement.
Thanks,
Roshan