Danny Tramnitzke wrote:
>
> 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.
ok, now we as readers know that you are using Oracle-sqlmode. then it is correct.
> 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"
date/time/timestamp-values are similar to character-values --> have to be surrounded by
single quotes ==> reaction is correct, because there is no implicit transformation
number --> timestamp
> insert into toti106 values
> ('keyone','keytwo','19990123143008456234','I','userId06')
>
> returns the message : "Invalid date input value"
you are using Oracle-sqlmode. And oracle has its own default date-format
DD-MON-YY where MON is the 3-letter abreviation of the month, for example
'11-FEB-03' is a fine date-value.
If you do not like this format, you can use the function to_date.
But if you are using ODBC/SQLStudio, you have to use the iso-format.
This is the restriction of ODBC.
>
> so, how can I fill the table with accurate values ??
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
