Hi all
I have a Table with following structure :
CREATE TABLE toti106 (
type_key VARCHAR2(30) NOT NULL,
attribute_key VARCHAR2(30) NOT NULL,
mod_stamp DATE NULL,
mod_flag CHAR(1) NULL,
mod_user VARCHAR2(20) NULL
)
the colum 'mod_stamp' has a timestamp format after creating the table.
now I want to fill that table with values, but there are problems with the
timestamp
insert into toti106 values
('keyone','keytwo',19990123143008456234,'I','userId06')
returns the message : "Constant must be compatible with colum type and
lenght"
insert into toti106 values
('keyone','keytwo','19990123143008456234','I','userId06')
returns the message : "Invalid date input value"
so, how can I fill the table with accurate values ??
Danny
--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
NEU: Mit GMX ins Internet. Rund um die Uhr f�r 1 ct/ Min. surfen!
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
