Hi Alejandro
> -----Original Message-----
> From: Alejandro Michelin Salomon [mailto:[EMAIL PROTECTED]
> Sent: Freitag, 28. Februar 2003 12:37
> To: Sapdb General List
> Subject: RE: SqlMode in ODBC Connections
[some stuff snipped]
> >>>I.e. SQL statements like
>
> >>>create table mytable (tcol time)
>
> >>>insert into mytable set tcol = {t '12:34:56'}
This works with SAP DB and ODBC.
>
> I this ok for sapdb :
>
> INSERT INTO accesslog ( Date, Time, User, Ip )
> VALUES ( set tcol = {t
> '01/02/2003'},'12:34','alejandro','200.248.150.44')
Try
insert into accesslog values ( {d '2003-02-01'}, {t '12:34'},
'alejandro','200.248.150.44')
BTW, did you really read thoroughly what I wrote?
Regards Thomas
----------------------------------------------
Dr. Thomas K�tter
SAP DB, SAP Labs Berlin
SAP DB is open source. Get it! www.sapdb.org
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
