Thomas wrote :
>>>-----Mensagem original-----
>>>De: Koetter, Thomas Theodor [mailto:[EMAIL PROTECTED]
>>>Enviada em: sexta-feira, 28 de fevereiro de 2003 05:22
>>>Para: 'Alejandro Michelin Salomon'
>>>Assunto: RE: SqlMode in ODBC Connections
>>>>
>>>> In order to enter date, time or timestamp within a SQL-statement,
>>>> you can use the format { type 'value' } where type is one of
>>>> d, t, ts and
>>>> value matching yyyy-mm-dd hh:mm:ss[.fffff] depending on the type.
>>>>
>>>> Examples:
>>>>
>>>> {t '12:34:56'}
>>>> {ts '1969-07-20 10:56:00'}
>>>I.e. SQL statements like
>>>create table mytable (tcol time)
>>>insert into mytable set tcol = {t '12:34:56'}
>>>Regards Thomas
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')
Or have to be diferent ?
>>>----------------------------------------------
>>>Dr. Thomas K�tter
>>>SAP DB, SAP Labs Berlin
>>>SAP DB is open source. Get it! www.sapdb.org
Thanks
Alejandro Michelin Salomon
PROBrax e-Tech
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
