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.

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