Thanks a lot for help me
I used win32 SQL Studio 7.4 with a database(sapdb 7.4) on linux.
and there comes also a errormessage (invalid date format), when I take the
ISO timestamp format
'1999-01-23 14:30:08.456234' insteat of the internal format ...
BTW : is the "repmcli" also a ODBC based ?
Danny
> Hi.
>
> As you can read in the Reference manual:
>
> "The date and time format determines the format in which the date, time,
> and
> timestamp values may be represented in SQL statements and the way in which
> results are to be displayed.
>
> The date and time format is determined when the database system is
> installed.
>
> Users can change the date and time format for the current session by
> setting
> the relevant parameters in the database tools or by specifying the
> corresponding parameters when using programs.
>
> The ISO date and time format is used by ODBC and JDBC applications and
> cannot
> be replaced with a different date and time format."
>
> So, the second insert statement would be ok if you were using dbmcli:
>
> dbmcli>sql_execute insert into toti16insert into toti106 values
> ('keyone','keytwo',19990123143008456234,'I','userId06')
>
> But if you're using an ODBC based application such as x_sql or the websql,
> you must use the ISO formats for timestamps: '1999-01-23 14:30:08.456234'
> instead of the internal format.
>
> Un saludo. Jos� Ignacio.
>
> 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.
> >
> > 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
>
--
+++ 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
