What does arrogance gain us?

----
vijay,

Lookup timestamp (although I'm not 100% certain this did not start in 9i).

define the column as timestamp;

insert into temp_table (COL1) values (timestamp '1999-12-01 11:30:55.3');

SQL> select col1 from temp_table;

COL1
---------------------------------------------
01-DEC-99 11.30.55.300000 AM

SQL> desc temp_table
Name Type Nullable Default Comments
---- ---------------- -------- ------- --------
COL1 TIMESTAMP(6)(11) Y



INSERT into temp_table (col1) SELECT substr(CURRENT_TIMESTAMP,1, 26) FROM DUAL