systime

[abhabhishek]

I just wanted to know tht is thr any way out tht while creating a table i can put a column with the datatype time and tht too the time be automatically inserted as the current systime

[debasisdas]

As you have posted a question in the article section it is being moved to Oracle Forum.

MODERATOR.

[debasisdas]

Oracle does not support TIME data type . You can do that with DATE data type.

By using DATE you can store both date and time informations.

[gintsp]

I just wanted to know tht is thr any way out tht while creating a table i can put a column with the datatype time and tht too the time be automatically inserted as the current systime

SQL> create table zz (a date default sysdate);
 
Table created.
 
Elapsed: 00:00:00.06
SQL> insert into zz values (default);
 
1 row created.
 
Elapsed: 00:00:00.01
SQL> select to_char(a, 'YYYY-MM-DD HH24:MI:SS') from zz;
 
TO_CHAR(A,'YYYY-MM-
-------------------
2007-08-02 10:23:10
 
Elapsed: 00:00:00.04
SQL> 

Gints Plivna