How to insert of only system time(hh:mi:ss) into table columnnot in the format of 'dd/mm/yyy hh:mi:ss' only system time not date.

Showing Answers 1 - 3 of 3 Answers

Waseem Mehmood
Profile Answers by Waseem Mehmood

Nov 20th, 2007

CREATE TABLE table_name
(col1 VARCHAR2(20));

INSERT INTO table_name
VALUES
(TO_CHAR(SYSDATE, 'HH:MI:SS'))

While creating table you must keep in mind the datatype must be Varchar2 for required column